I have a Form (form 1), I use to INPUT data into a table (Table 1). I also have a Dropbox on Form 1, where I can select data from another table (Table 2).
The data I select from Table 2, has a field in Table 1 for the item selected.
I can select the data from Table 2 for entry into Form 1, this is OK. When I go to the next record on Form 1, whatever was in the Dropbox in the previous record now goes into this record. How do I not have this happen when I am moving back and forth in Form 1?
I would appreciate any advise.
kevsim
The data I select from Table 2, has a field in Table 1 for the item selected.
I can select the data from Table 2 for entry into Form 1, this is OK. When I go to the next record on Form 1, whatever was in the Dropbox in the previous record now goes into this record. How do I not have this happen when I am moving back and forth in Form 1?
I would appreciate any advise.
kevsim
