Cmd button multiple criteria - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Cmd button multiple criteria

Mark Budinger

4 years ago

I have a form called Job_Points and a form called frmQCInspections, there is no relationship between them.

I do most of my work in the frmQCInspections form. Both of these forms have a common filed in them "Part_Number"

I would like to create a command button in frmQCInspections that will open the Job_points form via the part number field
and the Job_Open/Closed (Filed in the Job_Points form) field but only if this field is set to Open, Incomplete, RTR

I only know how to do a single filter through the macro builder. When converted to VB this is what I have

DoCmd.OpenForm "JOB_POINTS", acNormal, "", "[JOB_PARTNUMBER]=" & "'" & PartNoID & "'", , acNormal

Any help would be greatly appreciated.

Regards,

Mark

Kevin Yip @Reply

4 years ago

It looks like you need to add one more criterion to the one you already have, and connect them with the AND operator. The following code assumes the [Job_Open/Closed] field is a string, and that Open, Incomplete, and RTR are three different, possible values for [Job_Open/Closed]:

Dim crit As String

' The following criterion is true if [Job_Open/Closed] equals to any one of the specified values.
crit = "[Job_Open/Closed] IN ('Open', 'Incomplete', 'RTR')

DoCmd.OpenForm "JOB_POINTS", acNormal, , "[JOB_PARTNUMBER]='" & PartNoID & "' AND " & crit

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View