If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter cbo once record is added
I have 3 tables (tblProgress, tblStreet and tblHouses)
tblProgress is to store each worker's daily progress. tblStreet and tblHouses stores the street and the individual houses on each street. Each day the worker returns to the office, eneters his name, and date and picks the street he has been working on from a cbo. This all happens on a main form. Within the main form is a subform which is where the worker logs the information received about each house (the information such as name and date remain constant for each record hence the subform). I have it set up so that the house cbo box on the subform is filtered by the street chosen in the main form (thanks to Al Campagna for this), so the houses available in the housecbo are dependane on the street selected - This all works great. My problem is that if I select a house and then add all the details about that house and eneter all that as a record, the form then needs a second house selecting in order to enter the details for that house - but the first house is still in the list. I want it, once entered tonot be available in the cbo box. That way the worker knows when all the houses on that street have been entered. Andy |
Thread Tools | |
Display Modes | |
|
|