Combo box that will select and Go To a record on a form?

[Dale G]

Hi, I’m using Vista and Access 2007. I’m trying to create a form that will
work on Access 2003.

A lot of the Access 2007 DB examples have a combo box on one or more of the
forms, referred to as (Go to) and when a name is selected the form will go to
that record.

I created a form and tried to copy and paste the combo box, but some of the
built in functions are not in 2003. I think the trouble is with the
(SearchForRecord) Action.

I was hoping someone would know a way to achieve the same results, with a
Macro or VBA code.

My form name is frmEmployeeDetails.

The combo box gets info from,

SELECT qryEmployeesExtended.EmpNo, [LastName] & ", " & [FirstName] AS
Employee, qryEmployeesExtended.HomePhone FROM qryEmployeesExtended WHERE
((([LastName] & ", " & [FirstName])<>Nz([Employee],0))) ORDER BY [LastName] &
", " & [FirstName];
Any help will be appreciated.

 

[Dale G]

Never Mind I found it.
here's where,
http://allenbrowne.com/ser-03.html

 

[Ambyr via AccessMonster.com]

Thank you for posting where you found it.

Never Mind I found it.
here's where,
http://allenbrowne.com/ser-03.html