One query cannot store 2 different textbox in different forms

accessman2

Registered User.
Local time
Yesterday, 23:27
Joined
Sep 15, 2005
Messages
335
One Query cannot store 2 different textbox in different forms:
Query Name: rem

Form Name: QR
Form Name: Pro

Query parameter: Forms!QR!txtbox1
Forms!Pro!txtbox2

I tried it, it cannot run.
If you run the form "Pro" and run the query rem, then you will get the message:
Forms!QR!txtbox1?????

same thing if you run the form QR and the query rem
 
Please be more specific or post your database so we can take a look.

Greetz,

Seth
 
Wrong approach...
Use two queries or use a dynamic query in VBA to pass your conditions along.

RV
 

Users who are viewing this thread

Back
Top Bottom