combo box query

T

tag

I would like to use a query as the combo box rowsource.
The combo box should list out the available site number.
(that means, display the remaining site no other than
those booked, reserved and suspend)

Table includes AllocationDetail [Booked site] - location ,
site no
Site Master [All site no] - location, site no
Site Reservation - [All reserved site] location, site no
Site Suspension - [All suspend site] location, site no

Thanks for help!
..
 
Top