Hi,
does anyone know the correct syntax in an SQL string as part of the Recordset Open method to refer to a field on a form.
I currently have -
rstBookingsSchema.Open "SELECT * FROM BookingsSchema WHERE Date = " & Forms!BookingForm!Date & " ORDER BY Period", conn, 1, adLockOptimistic.
This does not return any records even though the Date does exist in the table BookingSchema and on the form.
The form is obviously called BookingForm and the field is Date. I have tried many variations of this and have had no luck. I need to be able to use the Date criteria.
Help!!
does anyone know the correct syntax in an SQL string as part of the Recordset Open method to refer to a field on a form.
I currently have -
rstBookingsSchema.Open "SELECT * FROM BookingsSchema WHERE Date = " & Forms!BookingForm!Date & " ORDER BY Period", conn, 1, adLockOptimistic.
This does not return any records even though the Date does exist in the table BookingSchema and on the form.
The form is obviously called BookingForm and the field is Date. I have tried many variations of this and have had no luck. I need to be able to use the Date criteria.
Help!!