Find a specific record

[Mary Hartman]

I am trying to put a command button on a form that will make a pop up
window to enter data for the field "product_model" and allow me to go
to a specific record by the field "product_model."

I can't seem to find the right set of command button selections to do
this.

Thank you

 

[Mary Hartman]

On Wed, 27 Dec 2006 17:39:57 -0500, Mary Hartman

I found a way to do this in an earlier post from Al Campagna, but if I
enter a model that has been deleted, I need it to pop up a message or
something so that someone who's not looking won't think the record in
front of them is the right record and delete that one.

 

[Mary Hartman]

On Wed, 27 Dec 2006 18:26:16 -0500, Mary Hartman

That's if they type in the model number which they probably will
rather than grab them from the drop down in the combo box because
there are over 15,000 model numbers.

 

[Larry Linson]

That's if they type in the model number which they
probably will rather than grab them from the drop
down in the combo box because there are over
15,000 model numbers.

Agreed that's too many just for scrolling, but with with the Auto-Expand
property of the ComboBox checked (enabled, is enabled as the default), you
can type into the ComboBox and it will scroll to the nearest match. Locate
it in the Form Header and the Wizard will prompt you, if you choose to use
it to locate a record. It's a good check that what you are searching for
does actually exist.

Larry Linson
Microsoft Access MVP