I have a combo box on a form as a lookup values within the table. The box works ok. it uses an embedded macro
Record First Where Condition , , First, = "[Vendor_Number] = " & "'" & [Screen].[ActiveControl] & "'"
I need the combo box to match the vendor number box as I move from one record to another recovery and keep synchronized between the information on the form and the combo box.
Any ideal how to make this work.