Tying a combo box to other fields and navigation buttons

[TigerGyrlAlly]

Is there anyway to tie a combo box to the rest of the data on a form and also allow it to work with the form controls (first, back, next, last) on the form?

I have a combo box on my form which I can use to select a number, causing the remainder of my form to become populated with the corrected data. If I select a new number from the box, the data changes accordingly. The data changes when I select one of the arrow buttons on the bottom of the form as well, that is, everything except my number in the combo box.

I bound the combo box to the field that it corresponds to in the table and then I could only change the data on the form if I used the access controls at the bottom of the form which does not work for me.

Is there anyway (using properties or code) to tie my combo box to the correct field and allow the data on the form to change accordingly (including the combo box) regardless of what method is used to select a particular record?

Anyone with any suggestions please tell them to me!!!!

Thanx in Advance

 

[PerkinsSlave]

Have you experimented with the code underlying the button? For example:

Private Sub cmdNextRecord_Click()

DoCmd.GoToRecord , , acNext
me.cmbYourComboBox.Value = Whatever

End Sub

I'm just throwing that out there, I haven't actually tried it with any data.

 

[TigerGyrlAlly]

I thought about doing something like that, but I didn't add any buttons to the form. There are just those that access automatically puts onto the forms

 

[PerkinsSlave]

Did you run the wizard to generate the form? What buttons did it place on the form?