Using MS Access/Custom Dialog forms/parameter queries
It has been a while. How have you been? I hope things are going well for you. I have to thank you again for your help last year with my database. so far, so good, all seems to be going well with it. I am currently working on another database where I am using a custom dialog to open a form. I have done these many times before with no issue, but I have always used them to open a report. So when I go to open the form, first I see a parameter box that states: forms!shipshearch!cboship. then, after I type the value or leave blank, the custom dialog box appears with the drop down to choose the ship. Then the form opens. How can I make the parameter dialog with the criteria for my form to open disappear. Thanks so much for all of your help!! As always, it is appreciated more than you know. Carla :)
When you get a parameter prompt like that it generally means that Access can't find the control referenced. I suspect here that you are using a bound form for the dialog box and it should be unbound.
Personally, I prefer just opening the form with a Search combo in the form header.