Is it possible to query using a public variable as the criteria ? I set up the public varible for the Part Number text field in my module using:
Public varGlobalPN As Variant
This variable can be reassigned on different several forms using a combo box. I'd like to be able to run the query and display a continuous form based on the value of this part number variable.
Also, how would I display a public variable on a form?
Public varGlobalPN As Variant
This variable can be reassigned on different several forms using a combo box. I'd like to be able to run the query and display a continuous form based on the value of this part number variable.
Also, how would I display a public variable on a form?
