anyform[fieldid] query ?

[mrrayj60]

I find myself having to make a new query for each form I make because the (where) is a different form name, can/is there a way for anyform[same field name on different forms] be used? Is that a valid statement? anyform?

Ray

 

[Galaxiom]

If the forms are the same except for the where clause you could just have one form. In the OpenForm method include the where clause to suit the current task.

http://msdn.microsoft.com/en-us/library/aa141520(office.10).aspx

 

[namliam]

Another alternative might be to make a public variable, store you value in that from the form.
Then have only 1 query using a function to retrieve the value...

 

[DCrake]

See this Link. This is a perfect example of what you need.

David