Where Condition

  • Thread starter Thread starter daisy
  • Start date Start date
D

daisy

I am creating a command button on a form so that when it
is clicked, it opens another form. But I am having
trouble with the Where Condition in the SQL statement for
that button. I want the second form to open but only
give me records where the field "grade" is equal to 6.
How do I write that? Thanks!
 
daisy said:
I am creating a command button on a form so that when it
is clicked, it opens another form. But I am having
trouble with the Where Condition in the SQL statement for
that button. I want the second form to open but only
give me records where the field "grade" is equal to 6.
How do I write that? Thanks!
Click to expand...

DoCmd.OpenForm "FormName",,,"grade = 6"
 
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

Opening a form from another form aqccess2007 2
register student to course 0
Access Automatically Send a notification email once a record is added 0
Separate Form 0
Validation Rule assistance 0
Conditional formatting -can I test for emptiness? 5
error 2489 1
Counting multiple memberships 1

Back
Top