Table Currently In Use ?

[JpSkyPilot]

Hi

I am building a form that has three subforms
1. The first sub form lists individuals from Employees and then we can select the vehicles they usually drive and the days that they usually work (based on a query that selects all from the Standard Assignment Table)

2. the second subform I then wanted to put a sub form that would display the names of the employees not yet used on the first sub form.

3. Then the third form would show what vehicles have not yet been assigned on the first sub form.

Right now there are about 10 employees not in the first table and about 5 vehicles unassigned.

When I try to open the form with all sub forms, I get an error stating that the "Standard Assignment" Table is already in use exclusively by someone else. It opens the first subform, but not the second or third.

Does anyone know how to do this?

Thanks for any and all assistance.

:banghead:

JP

 

[spikepl]

Using subforms just to select records is massive overkill and it also makes Access complain about mutiple access paths to the same table, as you've experienced.

Use listboxes.