query parameter value realspido 03.07.2006 12:55:27 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"

Re: query parameter value "Ken Snell \(MVP\)" <kthsneisllis9[ at ]ncoomcastt.renaetl> 03.07.2006 15:58:43 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 -- Ken Snell <MS ACCESS MVP> "realspido" <realspido[ at ]discussions.microsoft.com> wrote in message news:55D667CC-FEDD-472E-AB40-72E0F72AB6FD[ at ]microsoft.com... [Quoted Text] > 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"