query parameter value

[realspido]

Hello again,
On my form I want to make a button with assigned to it macro which will run
append-query. The query contains a parameter which value I want to be taken
from one of fields on the form (let's say called DateX).
Can anybody help me with it? I know it's simple, just can't find suit.
command in help file.

?????? = Me.DateX
DoCmd.OpenQuery "qryDLRnew"

 

[Ken Snell \(MVP\)]

Does the query contain the parameter that looks for the form's control's
value? That parameter should look something like this:

Forms!FormName!ControlName