Disable parameter prompt when opening form

N

NKK

I have a form with 6 dependant combo boxes (2 groups of 3); datasource1,
table1, column1, datasource2, table2, column2. I have an after-update event
to requery the "next" control on datasource and table and I have a
parameterized row source for table and column that take the value from the
"previous" control (So, table 1 takes datasource_id from datasource 1, etc.)
This form is for the user (me) to enter entity relationship information. I
would like to be able to open the form without the parameter query prompts.
I could have sworn I had done this before, but for the life of me I can not
remember how and I can not seem to find any examples either. Please help!
Thanks!
 
A

Arvin Meyer MVP

If you've saved the filter in the form, you'll need to go into design view
and delete the filter. If not, it probably is in the underlying query, and
you'll need to clear that criteria.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top