Form Filter

[scott04]

I have a database that is in use that uses a switchboard upon opening the
database. There are buttons on the switchboard that create a new record in
add form and another for edit an existing record. One of the fields i have
in the database is case#. Is there code i can use such that on the click of
the button the prompts me for a case number to take me to only that one case
number. I was thinking this is a better option than giving all records.
Thanks for any thoughts or suggestions.

 

[Beetle]

You could create a separate small popup form with an unbound textbox to input
a case # and a command button to open the case form based on that value. Then
you could have your switchboard open the popup form instead of the case form