puakenikeni
Registered User.
- Local time
- Today, 01:50
- Joined
- Jun 24, 2008
- Messages
- 25
I apologize for having so many questions today!
I have a form that has tabs in it with record source as the table "Master". The first form uses the fields from the Master table so that the user can input data into the table. The second tab is used to query the existing data in the Master table using a subform. The combo boxes have the same control source as the controls on the first tab, so whenever I make a selection on the combo box on the second tab, it "changes" the selection on the first tab as well.
How do I stop it from doing that? I don't want to accidentally change the data on the input side (first tab) or change the query information on the lookup side (second tab). I want things to be kept separately, but get its values from the same table.
I have a form that has tabs in it with record source as the table "Master". The first form uses the fields from the Master table so that the user can input data into the table. The second tab is used to query the existing data in the Master table using a subform. The combo boxes have the same control source as the controls on the first tab, so whenever I make a selection on the combo box on the second tab, it "changes" the selection on the first tab as well.
How do I stop it from doing that? I don't want to accidentally change the data on the input side (first tab) or change the query information on the lookup side (second tab). I want things to be kept separately, but get its values from the same table.