Solved filtering a sql query using a drop down box (1 Viewer)

[Eureka99]

Hi Guys,

I have a query that is using a SQL query. I want to use a filter to filter this by user ID. I have the below query, but I keep getting a Runtime 3061 error.

The filter returns an integer value and the tbl_meeting.UserID is a number field.

Can someone advise?

If Me.cbofilter = "Meeting" Then

strSQL = "SELECT Tbl_Meeting.MeetingID, Tbl_Meeting.UserID, Tbl_User.[UFirstName] & ' ' & [ULastName] AS Name," _
& " Tbl_MeetingRoom.MeetingRoomName AS Room, Tbl_Meeting.MDate AS [Date], Tbl_StartTimes.LookUp24Hour AS Start, Tbl_StopTimes.LookUp24Hour AS Stop, Tbl_Meeting.MSubject AS Subject" _
& " FROM ((Tbl_MeetingRoom INNER JOIN (Tbl_User INNER JOIN Tbl_Meeting ON Tbl_User.UserID = Tbl_Meeting.UserID) ON Tbl_MeetingRoom.MeetingRoomID = Tbl_Meeting.RoomID) " _
& " INNER JOIN Tbl_StartTimes ON Tbl_Meeting.MStartTime = Tbl_StartTimes.LookupScheduleTime) INNER JOIN Tbl_StopTimes ON Tbl_Meeting.MStopTime = Tbl_StopTimes.LookupScheduleTime" _
& " WHERE (((Tbl_Meeting.UserID)=[forms]![frmCalendar]![CboUfilter]));"

 

[arnelgp]

you concatenate it here:

... " WHERE Tbl_Meeting.UserID = " & Nz([forms]![frmCalendar]![CboUfilter], 0) & ";"

 

[Ranman256]

does the combo box hold the login userID: bSmith
or does each person have #: 12345

if the combo uses login names but is returning a #, then change the combo bound column.

 

[Eureka99]

It contains a number, arnelgp's solution fixed the issue

​