Blank Forms

[kbreiss]

How do I get the textboxes and subform to be blank upon opening? When I open the form it always defaults to the first record.

Thanks in advance,
Kacy
________
Vaporite replacement parts

 

[Tim L]

You could force the form to go to a new record by putting the code for a New Record in the On Open event of the form; this should leave all the boxes blank, ready for input.

I can't quote the code from scratch but if you create a new button using the button wizard (and choose Record\New) you can then copy the relevant line from the button On Click event into the form On Open event. (You can then delete the code and button from the form.)

HTH

Tim.

 

[Mitch_____W]

Set the form's "Data Entry" Property to "Yes"....

 

[Tim L]

In Access 2k the code to create a new record is:

• DoCmd.GoToRecord , , acNewRec

Incidentally, setting the Data Entry property to Yes will have the side effect of stopping records that have already been entered from being viewed.

HTH

Tim