ACCESS FEED: RE: [MS_AccessPros] How to open a form with multiple conditions

Sabtu, 03 September 2011

RE: [MS_AccessPros] How to open a form with multiple conditions

hi David,

remove the delimiters around the 2nd part -- numbers are not delimited

" AND [CustomerVehicleID] = " &
[Forms]!frmCustomerContactData!frmCustomerVehiclesSub.Form!VehicleMakeID

warm regards,
Crystal

* have an awesome day :)

--- On Sat, 9/3/11, David Tolson wrote:

>
> "Data type mismatch in criteria expression"
>
>
>
> From: djsdaddy531

>
>
>
> 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
>
>