Docmd.OpenForm With Multiple Parameters

Hi everyone,

I received a question as a result of one of my other posts:

How To Open A Form To A Specific Record In Access 2016 VBA

please help me. i’ve been trying to solve this problem but didn’t success. how to open a specific record in access 2016 with two conditions? for example i want to open a specific record based on Company Name and Contact Title.

…So it would be helpful to clarify this a bit more.

So what happens if you want to specify more commands in your “wherecondition”?

Here’s a little example:

The following image is of a selection form asking for 2 selections, “Employee” and “Shipped Via”

The form just contains 2 combo boxes, nothing special.

…and it opens this:

…just based on the 2 criteria I asked for on the previous form.

The code behind the command button is pretty straight forward:

DoCmd.OpenForm "frmOrders-20200530", acFormDS, , "[EmployeeID]=" & Me.cboEmployee & " AND [ShipVia]= " & Me.cboShipVia

Here’s another code example based on something totally unrelated:

DoCmd.OpenForm "frmName", acFormDS, , "[FirstName]='Alex' AND [ Class ]= ''2A'"

DoCmd.OpenForm "frmName", acFormDS, , "[FirstName]=" & Me.cboStudentNumber & " AND [ Class ]= '" & Me.cboClassName & "'"

Please note that if the value is text, you need to enclose it in apostrophes, but not when the value is a number.

Let me know if you have questions.


Comments are closed.