Text box on a form

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I want to use a textbox from a form I've created as criteria in a query.
Can anyone tell me the poper syntax for this? form.frmname.txtstartdate?
Thanks for your help.

Chris
 
Set the criteria to refer to the textbox on the form. What you have is
close, you need to add an "s" to "form". Access will put brackets around the
entry though, so it will look like:

[forms].[frmname].[txtstartdate]

If the control is on a subform, the "path" to it is a bit longer. Also, the
form must be open for the query to see the value. The form can be hidden
(Visible = False), just as long as it is open.
 
Back
Top