Find Box

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Is it possible to have the find box "pop" up every time
that i open a particular form? And if so, how do i go
about getting it to pop up? Thank you for your help in
advance!
Mark
 
Mark said:
Is it possible to have the find box "pop" up every time
that i open a particular form? And if so, how do i go
about getting it to pop up? Thank you for your help in
advance!
Mark
Click to expand...
Try DoCmd.RunCommand acCmdFind in the On Open event.

Roxie Aho
roxiea at usinternet.com
 
I appreciate the help Roxie, but honestly i have got no
clue on what that means. If you could kind of walk me
through it, like on how to get to each place that would
be great, because right now i am at whits end trying to
run this program, thanks again for the help!
Mark
 
Mark,
1. Open your form in Design View
2. If the Properties window is not visible, click View, then Properties to
make it visible.
3. If should say "Form" in the Title Bar
4. There are five tabs (Format, Data, Event, Other, All). Select Event.
5. Click the On Open row.
6. Click the elipsis (...) button that appears.
7. Depending on how you are set up you may get a dropdown list offering
(Expression Builder, Macro, Code Builder) or you may go straight to Visual
Basic for Applcations (VBA). Clicking on Code Builder takes you to VBA.
8. You will see:
Private Sub Form_Open(Cancel As Integer)

End Sub
9. Between the lines Private Sub... and End Sub, type DoCmd.RunCommand
(space) acCmdFind. Again, depending on how your Access is set up, the
program may try to help you. After you type DoCmd. you may get a dropdown
list. Type ru and RunCommand should be highlighted. Press the TAB key and
it will complete the command for you. After the space, another dropdown list
will give you commands. Scroll down the list to acCmdFind, click it with the
mouse to highlight it and press the ENTER key. It's faster than typing but
sure takes a lot to explain.
10. Go back to the Form
11. Save the form
12. Close the form
12. Open the form to comfirm that the Find dialog box appears.

Roxie Aho
roxiea at usinternet.com
 
Thank you so much Roxie, you helped me out a ton! You are
definately an access princess. Thanks again!
Mark
 
Back
Top