Help an idiot . . . Autonumbers (again)

[Cgrnc]

I posted this problem once and got one reply (that I didn't quite follow) under the subject: Autonumber and saving records.

Once again: I used autonumbers as primary keys in my tables. I have a Parent form with three text boxes and three subforms. The textboxes all have defaults in them at the form level. If one is using only the mouse and wishes to accept the defaults, clicking on one of the subforms produces the "Primary key is null" message because the record has not been saved.

How can I get the current record to save the defaults WITHOUT tabbing off the record or entering one of the text boxes?

In the reply to my first posting someone suggested saving a recordset for one of the subforms. . . how do I go about this?

Thanks (again) for any responses!!!!

 

[yahazim]

ALL RIGHT. This worked for me, and of course very simple once figured out.

Try Refreshing the form OnActivate.

--------------
Private Sub Form_Activate()
Me.Refresh

End Sub
--------------

Jim

 

[Cgrnc]

This didn't work for me but THANKS SO MUCH for the reply!!

Any other ideas?????

 

[Cgrnc]

Right you are!!! Thanks for the suggestions. I've got difficult users who want what they cannot have . . . I'll just have to learn to says so!!!