store value to use a criteria for query

[kwtmd]

How do I store a value of a number field from a selected record, to use in a query later?

 

[Cosmos75]

Are you trying to use the value shown on a form as criteria for a query? If so, you would just have to refer to the control on the form in your query (i.e. Query by form). Be aware, that I believe that you can't use a field from a record if your form or sub-form in a continuous form.

Also see [FAQ] Referring to objects in Access: ! and . and (" ") notation.

If I have missed the mark, post pack and we'll try to help you out!


Edit: I just noticed that you tried asking this before.

 

[kwtmd]

still trying

I was trying to use a value of a number field from a subform, 'store it' somehow as a variable that was referred to in a query, then run the query (all automatically). I am struggling with where data is 'kept' and how to recall and use it. I had tried to save the value as an integer with VB code.