ListO
Señor Member
- Local time
- Today, 02:27
- Joined
- Feb 2, 2000
- Messages
- 167
Greetings, all.
I'm searching for some big-picture suggestions about how I should go about the following:
I have several combo-boxes on a form which pull their lists from other tables. If a user types an entry that is not in the list, I would like to give them the option of adding new items into the connected table, then continue data entry at the same place on the first form with the combo-boxes.
Problem is that if I move control to a form which allows entry into the underlying tables, when control returns to the first form, the combo-boxes still do not accept the new entry. The only thing I've found that works is to close the first form, make new entries into the tables, then re-open the first form and re-enter data up to the combo-box in which I added the entry. This is not a good choice, and I wonder if there is a better way?
I'm searching for some big-picture suggestions about how I should go about the following:
I have several combo-boxes on a form which pull their lists from other tables. If a user types an entry that is not in the list, I would like to give them the option of adding new items into the connected table, then continue data entry at the same place on the first form with the combo-boxes.
Problem is that if I move control to a form which allows entry into the underlying tables, when control returns to the first form, the combo-boxes still do not accept the new entry. The only thing I've found that works is to close the first form, make new entries into the tables, then re-open the first form and re-enter data up to the combo-box in which I added the entry. This is not a good choice, and I wonder if there is a better way?