combo box working but not dispalying values

[tweety]

Hi

i have a form with a combox box that read its values from a table





in the attachment the supplier combo box when opened will show other suppliers, after selecting a supplier from the list the contact name and number will also change, but when using the navigations on the right side the supplier name combo box value will not change alongside with the contact name and number

thanks in advance

[Missinglinq]

Your post is not really very clear, but if you're saying that the supplier doesn't change, appropriately, when navigating through Records, it sounds as if the Supplier Combobox is not Bound to a Field in the underlying Table/Query.

Linq ;0)>

[tweety]

sorry for not being clear but yes "that the supplier doesn't change, appropriately, when navigating through Records" what is the problem and what is the fix??

thanks

[ssanfu]

You are using the supplier combo box to find suppliers. This combo box is unbound - as it should be.
In the code for the 4 supplier buttons, you would add code to push the supplier PK into the combo box.

So in the code for "Next Supplier", add something like this as the last line of the sub

'combo box name ...... field name for supplier PK
Me.cboSupplier = me.supplierPK

Do the same for the other 3 buttons

[tweety]

Thanks for that,
i didnt have the primary key on the the form but i added it and hid it, also i added the same code from above and placed it on form start up as it didnt show there too

thanks again