Reference a string??

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
J

Jeff Klein

Can I reference a public string in a query? I have a query that references
a textbox on a form, but I want to use the query on other forms also. Can I
change the form reference to a public string? This way I could set the
string value and then run the query within any form. If so...How?
 
You can't reference public variables in queries (assuming that's what you're
talking about), but you can create a function that returns the value of the
public variable and use that in your query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using a string instead of a textbox 1
Appending zero-length string 3
Changing reference cell in query 2
result query on a form 1
OpenRecordset(queryName) refering to form 2
Change a string into a criteria expression 0
How to OpenRecordset(queryName refering to form) 12
passing a parameter based on multiple selections 7

Back
Top