Combo box and Form update

[2077delta]

I have a form based on a query that returns a product id and related info on the product. The form contains a combo box to allow the user to select the product id. This part works fine so when I select a different product id all the other information on the for changes accordingly. However, when I use the navigation buttons to cycle through the products, the text boxes change but the combo box doesn't show the product id for the new record. I know this can be done because the Orders form in the Northwind database works this way. However I can't seem to get my form to function the same way. How do I get the combo box to update to the product id for the new record when I use the navigation buttons?

 

[smozgur]

Assuming you meant "other record" with "new record" by using navigation buttons.

Goto Form_Current sub and put the following code:

Private Sub Form_Current()
  cmbProductID.Value = Me.ProductID.Value
End Sub

Suat

 

[bat17]

You need to set the control source for your combo box to the appropriate field in the underlying query

HTh

Peter

 

[2077delta]

Thanks for the help guys. I already had the ProductID selected from the current query. I tried inserting the code as suggested, but when I open the form, I receive an error message. The message says "Run time error 424. Object required." I thought the ProductID reference was the object. Also, I keep seeing references to "Me.(whatever)". How is this reference used? You must pardon my ignorance, but I'm new to this and I can't find any references to this nomenclature. Is there some parameter I have to set for this to work?

Thanks for all the help.