How to have a form "on start" prompt the user with a command button 1

[kimba45]

Hi
I am trying to get my form to prompt the user with a command button I created to search for a record.
I have 2 forms -obsform1 and obsform2. The command button is on obsform1. The command button name is cmdFind.
I am also trying to get the forms produce a blank record on start and instead it is producing the first record from a table and therefore records are being captured with blank fields in reports.
I am fairly new at VBA programming!

 

[Remou]

There is no need to load a recordset until you need it. If you set the recordset in design to:
Select * From tblTable Where 1=2
You will get a blank recordset.

As for the buttons, I am not sure what you mean. Do you want Set Focus, GoTo Control, a Modal form?

 

[ItIsHardToProgram]

docmd.openform obsform1 ??????

"Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.