How can I get a Blank form when Open

[rhonda11]

I have a form called Update Existing Projecst, that will only allow addition, no Data entry or Deletion. This form has a drop down combox that allow the user to pull the specific record to be update. My problem is that everytime I first open the form, it default to the very first record with the information appear as if this this was selected to be update. And to top it off, the combox for lookup the specific record was not even selected (blank). How can I have this form as a blank form until the user select a particular project Id from the combo box, then the information shall appeared.Any suggestion guys,I really need this to work. Please help.....thanks in advance

 

[scroce]

did you try specifying the form in Add Mode, i.e., something like:

docmd.OpenForm myForm,acNormal, acFormAdd

this may not be exactly the right syntac, but search on acFormAdd in Help, or OpenForm command in help.

If you're trying to force users only to enter a new record and not change the old ones, I believe that is one way it can be done. Q: Why is my computer doing that?
A: Random Perversity of Inanimate
Objects

 

[rhonda11]

Thank you for your reply, however, I'm not trying to have the user add new, this form is for update existing record only. My problem is, evertime this form opened, the first very first record appeared on the form. I want it to be a blank form until the user have selected a record from the combo box. The goal is to get this form blank when the user open it.

Thanks

 

[CosmoKramer]

One thing you might try is to make all of the controls on the form invisible when the form opens, except for the combo box, and make the controls visible when the user selects an entry from the combo box.

Or, you can set up an intermediary form that only has the combo box, and when the user selects from the combo box, open your current form with that record loaded.....

 

[rhonda11]

I've took your suggestion, thank you. The intermediary form works fine, however, when it brings up the form with the record that was selected from the intermediary form. My combo box in that main doesn't work for look up anymore. Where did I go wrong? I didn't change anything on that form. I just created the intermediary form that'll bring me to that main form with the selected record. However, If I open that main form for lookup record without going through the intermediary form, it works.