VBA code and query criteria

[elfranzen]

OK I have worked in Access for awhile now but never worked with SQL statements or anything like that. This is what I am trying to do I want a criteria in a query come from a public string that I have. When some one logs in to the database it stores what property they work for I only want records to show up for that property. I don’t want them to have to type in there property code again every time the query is run. What do I need to do to get this to work? Any help would be greatly appreciated. Thanks

 

[ajetrumpet]

Where is the property value stored?

You have to retrieve the value from its storage spot when you're writing the criteria section of the query.