One Query for two forms

[basilyos]

hello


i have 2 forms and on update query based on user id
so i want to run the same query if form1 is open or form2


i put on criteria


[forms]![form1]![uid] or [forms]![form2]![uid]


but when run query form1 a dialog appear ask me for [forms]![form2]![uid]


and when run query form2 a dialog appear ask me for [forms]![form1]![uid]


mhy solutio is to make two seperated query but could i solve this problem with just one query

 

[Gasman]

You don't say how you run the query.?

 

[basilyos]

command on click from the opened form

 

[Deleted member 147267]

Methinks your only other option besides 2 separate parametized queries would be to build the query sql with vba (code). By referring to form controls in the query, you've eliminated the possibility of having one query. Even if both forms were open and one hidden because the user shouldn't see it, it still wouldn't work because the invisible form controls would be empty.

Even then, as code you would require 2 procedures, one for each form, even if they were only one-liners that called the same public sub. Probably easier for you to have separate queries.

 

[Gasman]

command on click from the opened form

OK
You could use a querydef and assign the parameter.

See post 12 here for syntax https://www.access-programmers.co.uk/forums/showthread.php?t=299953&highlight=update+querydef

You can use a saved query name as well. I just can't find an example at the moment.

Or you could set a Tempvar from the form value and use the TempVar in the query. I have dome that before finding out about querydefs.

HTH