assigning recordsource to tab

J

Jim

Also when opening the form one of the delays is the main
form want to bring in all the records of the query. I use
a combp box to find the correct record. Is their a way to
open the main form without bringing in any records?

Thanks

Jim
 
R

Rick Brandt

Jim said:
Also when opening the form one of the delays is the main
form want to bring in all the records of the query. I use
a combp box to find the correct record. Is their a way to
open the main form without bringing in any records?
Click to expand...

Open initially with an impossible criteria like "1=0"
 

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

Similar Threads

QBF & Query Malfunction 0
filtering a form based on the values of a subform 0
Unremovable horizontal scroll bar on subform 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
First Subform record gets modified when closing form 3
iif exists - too complex? 0
Subform opens blank 0
Filter on Subform Not Displaying as Expected 1

Top