Not Exists Access Query
I am trying to limit the list of a combo box based on a query. The combo box should contain a list of apartments that do not have matching fields between tblApt.AptID and tblRental.AptID.
In other words the apartments listed should only contain the apartments that are not rented.
In the attached DB if the query works properly it should not list apartments 1000-A through 1000-D.
You would see this in the form Create new Rental Switchboard Item.
Thanks,
Stuart
HCPV-Current.accdb
In other words the apartments listed should only contain the apartments that are not rented.
In the attached DB if the query works properly it should not list apartments 1000-A through 1000-D.
You would see this in the form Create new Rental Switchboard Item.
Thanks,
Stuart
HCPV-Current.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER