query parameter value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
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
 
Back
Top