Jaymin
Registered User.
- Local time
- Tomorrow, 02:59
- Joined
- Oct 24, 2011
- Messages
- 70
Hi all,
I have a form with two cascading combo boxes and a subform with a txt box, after you enter data into the cascading combo boxes the focus goes to the txt box in the subform, the data that is entered into the subform comes from serial numbers from two sets of clothing only four numbers, if you enter a serial number that has already been entered i have vba code that will search a table and tells you of this, but if you have mistakenly entered all of the serial numbers there is not a way to exit the subform and reset it so you can go back to the main form cascading combo boxes and enter another filter option.
Peter
I have a form with two cascading combo boxes and a subform with a txt box, after you enter data into the cascading combo boxes the focus goes to the txt box in the subform, the data that is entered into the subform comes from serial numbers from two sets of clothing only four numbers, if you enter a serial number that has already been entered i have vba code that will search a table and tells you of this, but if you have mistakenly entered all of the serial numbers there is not a way to exit the subform and reset it so you can go back to the main form cascading combo boxes and enter another filter option.
Peter
