Change query paramaters based on different forms 1

[eowyn12]

I have an append query that uses a variable on a form as a criteria.
The criteria of the query is something like this.

WHERE ((tblLoanTrans.ControlNo)=[forms]![frmLoanRO]![ControlNo])

I have another form frmLoanDD, with similar but slightly different controls.
I want to use the same append query using a criteria based on the textbox on frmLoanDD.

WHERE ((tblLoanTrans.ControlNo)=[forms]![frmLoanDD![ControlNo])

Is there any way to do this without making another append query with this criteria?
I tried to use a public variable, but couldn’t figure out how to put the public variable in a query.

Any suggestions would be greatly appreciated!

Yoko

 

[RoyVidar]

Hi!

In a public variable approach, you'll need a public function to retrieve the variable value.

In a module (not a forms module):

[tt]Public Function GetMyPublic() as <Datatype of the return value>
GetMyPublic = MyPublicVariable
End Function[/tt]

Substitute the <..> text with the return value data type...

In the criteria row of your query enter the function:

[tt]GetMyPublic()[/tt]

HTH Roy-Vidar

 

[eowyn12]

It worked! Thank you very much, Roy!
This was my first time asking a question on Tek-Tips, and got the right answer in less than an hour...happily surprised!
Thank you again!
Yoko

 

[RoyVidar]

My pleasure! Glad it worked out!

Roy-Vidar