opening a form with blank fields

[dumdum2]

I have a form that I would like to have blank fields when it is opened. Its record source is a table and I have a button on the form that is used to lookup data that is then added to the table via the button. But right now, the form opens and displays the 1st record in the record source table.

What's the best way to do this?

Thanks-

 

[PHV]

Set the DataEntry property to True.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ProgramError]

Have you tried goto new record?

Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.

 

[TheAceMan1]

or in code:

[blue]   Me.DataEntry = True[/blue]

See Ya! . . . . . .