Can anyone help me with a form issue? Please

[Guest]

Hello

I have a form which has around 100 records and I was wondering is it
possible to have a wee pop up search box that I can click open and enter
something in the fields to search for a record? If that makes sense.
Any help would be much appreciated.
Thank you
Access Beginner

 

[Guest]

The easiest way is to use the built in find feature available through the
Access menus. You can also add a command button to the form and assign the
find function to it using the wizard.

 

[Larry Linson]

Hello

I have a form which has around 100 records and I was wondering is it
possible to have a wee pop up search box that I can click open and enter
something in the fields to search for a record? If that makes sense.
Any help would be much appreciated.
Thank you
Access Beginner

If you have a primary key, you could (1) make sure the Control Wizard is
enabled (the little magic wand icon will appear to have been pressed in the
toolbox in design view), (2) place a Combo Box (a good place is in the Form
header), and (3) follow the Wizard's prompts to have the Combo Box locate
the Record.

Simple, straightforward, and the Wizard generates any necessary code for
you.

Larry Linson
Microsoft Access MVP