Open form with 2 criteria

  • Thread starter Thread starter Alan T
  • Start date Start date
A

Alan T

I need to open a form which need to satisfy 2 conditions.
I know how to specify 1 condition but no idea how to specify 2.
 
You can combine multiple conditions in the WhereCondition of OpenForm.

Essentially the WhereCondition has to end up like the WHERE clause of a
query, including the correct delimiters. This example shows how to use
criteria on a numeric field, a Text field, and a Date field:
Dim strWhere As String
strWhere = "(MyNumber = 1) AND (MyText = ""dog"") AND (MyDate =
#1/1/2007#")
DoCmd.OpenForm "Form1", WhereCondition:=strWhere
 
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

Access Dcount (multiple criteria) 3
Using WHERE clause when launching Reports from Code 4
option group 1
Conditional format a calculated field 2
Filter Form doesn't close 2
Programtically Setting Conditional Formatting For a Form In Access 2007 2
specifying which subdatasheet in Access 2003 3
Specifying conditional Criteria in a Query or Report 6

Back
Top