Hi Folks,
I spent the last seven hours trying to get this to work - me and Google are great friends!
I'm trying to get my bound form to populate a text box with a value (AppointmentDesc) filtered by the ClientID [ComboBox] and the Appointment Date selected in another ComboBox [SessionDate] My code looks like this:
The code is in the 'After Update' event of the SessionDate Combo.
I get a runtime error 3075 when the code is executed saying I have a syntax error but I just can't find it.
Can someone please put me out of my misery?
I spent the last seven hours trying to get this to work - me and Google are great friends!
I'm trying to get my bound form to populate a text box with a value (AppointmentDesc) filtered by the ClientID [ComboBox] and the Appointment Date selected in another ComboBox [SessionDate] My code looks like this:
Code:
Me.Text48 = DLookup("AppointmentDesc", "qrySample", "(ClientID = '" & Me.Combo42.Value & "') AND (AppointmentDate = #" & Me.SessionDate.Value & "#)")
I get a runtime error 3075 when the code is executed saying I have a syntax error but I just can't find it.
Can someone please put me out of my misery?