Subform Blues

[sdkramer]

I've got a form with a combo box control. that looks up the appropriate information in the subform after update. My problem is when the form loads the subform displays the first record's information until I select someone else in the combo box. Is there any way to have this subform display nothing until I select something?

 

[GKite]

Have it start off by going to a new record.

 

[sdkramer]

How do I do that?

 

[GKite]

On your forms control, set the 'on open' to run the following code:

DoCmd.GoToRecord , , acNewRec

That should do it! let me know

 

[sdkramer]

That worked. Thank you so very much