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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query using multiple values from one text box 7
Problem referring to a subform control from a query 5
Help with DCOUNT syntax 2
Entering criteria from form 2
Refer to a control in a subform 1
search multiple criteria 0
passing a parameter based on multiple selections 7
Using a Form to supply parameters to a query 13

Back
Top