Move to Record

[qvqv]

Hi



Is it possible to put a control on a record, like a drop down box, where you can select a record and Access will navidate to that record.

Many thanks

[Bob Fitz]

Hi

Is it possible to put a control on a record, like a drop down box, where you can select a record and Access will navidate to that record.

Many thanks

Yes. Usually done with a combo box in the Header Section of the form.
Assuming that the form is bound to a table/query you can use the wizard to create it. It will create a macro to find the record selected. There's even a wizard that will convert the macro into VBA

[ranman256]

find what, their name, their ID key,

by key:

sub cboFind_afterupdate()
me.filter = "[id]=" & cboFind
me.filterOn = true
end sub