Forum Discussion
Solved
How to keep combo box data from change between forms?
Hello,
When I input new data in a form in the combo boxes, that data is saved on the respective table. However, in the form view, when I go back to previous records, the saved data does not show up respectively. How can I keep the data from changing between form records?
My knowledge of access is fairly basic... I can provide further imgs and info if necessary.
Thank you.
- Are these by any chance "cascading combo boxes" where the list of records in one box is filtered by the choice in another? For example, if you pick a state in Box1 then you'll see only a list of cities from that state in Box2. If that's the case, then that would explain why you're not seeing any values. They're not in the list of options that combo box has because it's filtered. You'll need to requery the combo boxes in the OnCurrent event. https://599cd.com/OnCurrent
6 Replies
- How do you have these combo boxes set up? Are you just storing the text in the underlying table, or do you have them set up as properly relational combo boxes, storing an ID for each of these items? See https://599cd.com/Relational
Thank you for your quick reply. Your youtube videos have been very useful to me in this journey...
I think I have the combo boxes in a relational way, since the data on them depends from other tables as well.- OK, that combo box looks OK. Make sure you have the other two bound to the correct fields. As far as I can see from your screen shot, everything looks OK.
