View Full Version : Subform Blues


sdkramer
03-25-2002, 09:51 AM
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
03-25-2002, 10:19 AM
Have it start off by going to a new record.

sdkramer
03-25-2002, 10:21 AM
How do I do that?

GKite
03-25-2002, 10:41 AM
On your forms control, set the 'on open' to run the following code:

DoCmd.GoToRecord , , acNewRec

That should do it! let me know

sdkramer
03-25-2002, 11:06 AM
That worked. Thank you so very much