I attached the code. I am receiving a "Run-time error '13" message. When I debug the error it seems to be providing the criteria I am expecting. "GroupStatus.Value" refers to a lookup table and I believe that is possibly the source of the error. When I debug it shows a text string even though it should be an integer (i.e. column 0). If my premise is correct, in this example the proper integer "value" should be 508. Any assistance would be greatly appreciated :)

Hi Steve,
watch todays video that Rick provided. Even though it is about date, I think it will help you. What do you expect GroupStatus.value
to be? Are you comparing it to something?
John

Here is the proper syntax.
The first example hard codes the SalesRepID.
The second example gets the SalesRepID from a Combo Box.

Example 1
    DoCmd.OpenForm "OrderF", , , "CustomerID=" & CustomerID & " And SalesRepID=2", acFormEdit

Example 2
    DoCmd.OpenForm "OrderF", , , "CustomerID=" & CustomerID & " And SalesRepID=" & cboSalesRep, acFormEdit

Kevin - thank you so much! That addressed my issue perfectly.
John - I will watch the video and thank you for the recommendation.
Have a great day everyone.

You're welcome. Glad I could help.

Another option to the WHERE parameter in DoCmd.OpenForm is to just set the Form's source for building/testing.
I then clear that field in the designer and do a SQL statement in VBA and stuff it into the:
frm.RecordSource = wSql
  frm.Filter = cZls: frm.OrderBy = cZls 'should be nothing, all in source
  frm.FilterOn = False: frm.OrderByOn = False
later in the Form_Load procedure.
This gives me a lot of flexibility in the Where (filter) and Sort part which I can change later in the VBA code if necessary. This is used a lot in Search forms, but I also allow the users to define the filter & sort that works best for their organization from a supporting table field.