combo box saving changes when I don't want it to

[jbs0925]

So for work I've been asked to make a database that allows detectives to look up a known gang members information through a form. I made a form that has 2 combo boxes in it, both linked correctly to the subform, one for the persons race and one for their skin tone. The boxes always start on their respective first attribute and have the matching persons information shown below in the subform, when I select a new attribute they correctly find a person matching the changes. This is all well and good, but if I leave the combo boxs on the attribute I was searching for (and it is not the one they start out displaying)ad then click the close window button for the form or the next record button(there are 2 of these buttons, I'm talking about the lower one that scrolls through all the people in the database) they change the persons information in the main table and all related queries/forms to what the combo boxes were last set on. This becomes annying because it is easy to screw up someones information and then I have to go back to the main table and change it back to what it was. Is there any way that I can have the combo boxes work properly, but not change someones information if I click the "close" or "next" button?

 

[boblarson]

The combo boxes for searches should NOT be bound to a field and that's what it sounds like it is set up like. Remove the bound field and you should be fine.

 

[jbs0925]

thanks Bob, I had literally spent the last 2 days trying different things out to remedy this. for some reason I thought I needed them to be bound to the related field. it worked though, thanks man.

 

[boblarson]

No problem - glad we could help get you on track. And welcome to Access World Forums by the way