Query returning nothing

Schillers

Registered User.
Local time
Today, 21:17
Joined
Mar 17, 2012
Messages
23
SELECT TblCaravanBooking.[Booking Ref]
FROM TblCaravanBooking
WHERE ([Forms]![Booking History]![Caravan_No] = [TblCaravanBooking].[Caravan No]);

Is returning nothing?
 
Here are some questions that might help you get to a solution:

Are you inputting the caravan number exactly at it appears in the table?
Are you entering a carriage return, enter or tab after inputting the caravan number?
Are you keeping the booking history form open as you run the query?
Are all field, table and control names spelled correctly?
 

Users who are viewing this thread

Back
Top Bottom