combo boxes

[hinser13]

I have 3 combo boxes used as look ups

1: Client ID
2: Surname
3: Company Name

when you search any of the combo boxes and navigate to the account, the remaining combo boxes display the last search and not current client.

I have found a way to set the form current event for 1 combo box but how do I set all 3 to display current client?

I currently use:

Private sub form_current()
me.combo21.value=clientID
End sub

but I also need to set Surname & Company name, any ideas.

Thanks to any one that replies

Mark

 

[John Big Booty]

Just to clarify. Your three combos are unbound? and are used as search criteria for a query that is populating your form? and once a record has been located using the query you want to populate those three combos to reflect the current record displayed via the query