[MS_AccessPros] How to open a form with multiple conditions

 

Great Day, I have a form that I want to open a datasheet form with multiple conditions:

Here is the code behind the click condition that opens the form:

stDocName = "frmRepairOrder-Select4Report2"
stLinkCriteria = "[CustomerID]=" & Me![CustomerID] & " AND [CustomerVehicleID] = '" & [Forms]!frmCustomerContactData!frmCustomerVehiclesSub.Form!VehicleMakeID & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

The error message says

Syntix error in string in query expression '[CustomerID]=1 AND [CustomerVehicleID]= '2715'.

I suspect that it has something to do with the fact the Customer ID and CustomerVehicleID are numbers and not strings, but I have attempted different variations of ' " marks, but to no avail.

Thanks in advance for the help.

r/David

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 8
• New Files 4

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

---

A good Credit Score is 720, find yours & what impacts it at freecreditscore.com.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___