Find Record with a While Clause (filter)

[geraldk]

Hello,



I am looking for VBA code to find a record that would match a field from a form.

I am able to go to next record using: DoCmd.GoToRecord , , acNext, but I would like to have a while clause there match value from a text field.

I have an employee database that I would like find next record that would match a person name with their jobs history here. So, currently the user can click on a button and it will go to the next record without filtering the name, but I would like to only display records that would match the employee name.

Any help would be appreciated.

Thank you in advance.

[June7]

One method is parameterized query. Review: http://datapigtechnologies.com/flash...tomfilter.html

Another involves use of RecordsetClone. Review: http://www.blueclaw-db.com/access_findfirst.htm