Form Loads Empty When Openned From Switchboard

[nyamrembo]

Hi, I have a form that has a subform linked. The form loads fine with all the records. However, I created a switchboard that I want to use as a median for opening the form and some reports. The problem is that when i open the form from the switchboard, the form opens but it does not load any of the records. The form I am opening has a drop down combo box and the combo box has data but when i select the customer name form the combo box, it doesn't load. What have I done wrong or how can I get the records to load with form opened from switchboard? I don't have this problem when I just click directly on the form to open it. Please help!

Thanks

 

[dhookom]

It sounds like the form is being opened in Add mode. Make sure the form Data Entry property is set to No. You can also check the code used to open the form.

Duane
Hook'D on Access
MS Access MVP

 

[nyamrembo]

The form is opening in add mode and Data Entry Property is set to no. Any other ideas?

Thanks

 

[PHV]

Use acFormEdit instead of acFormAdd

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886