Parameter

  • Thread starter Thread starter Vina
  • Start date Start date
V

Vina

I have a query that has a criteria of Order number. I
have created a command button to run the query if they
will click on something in my form but how can i put in
the EVent procedure that the order number = to my a
particular variable.

In the query i have [Enter Order Number] can enter that
data using VBA?

Any ideas is appreciated.

Thanks
Vina
 
You can change the query parameter to look directly on the form for the
value.

i.e. Forms!FrmName!ControlName

or in the code behind for the button, open the form or report passing the
parameter like:

Docmd.OpenReport "ReportName", wherecondition:="EntityID=" & txtEntityID


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top