adding a record problem

[steph9x]

Hi, I'm fairly new to access but have some vb experience. Here's my situation.
I have 1 combo box and 1 textbox. The combo box selection determines the textbox value. I made an if statment that determines what the value of the text box will be according the the combo box selection in the afterupdate of the combo box. The problem is when I want to view another record the textbox value equals whatever the last record was. So basically the combobox selection changes all the records. Like I said I am new to access and I find this odd. Any help would be greatly appreciated.Thank you

 

[bonekrusher]

Sounds like the combo box is bound to a field in the the record source. Delete the combo box and used the wizard to create a new one. Dont choose the option that asked you to have it look up record on the form...

Hope this helps

 

[steph9x]

hey, great that worked thanks