How to find a specific record

[Erin Rachelle]

I'm creating a database for many users to access. I want a feature where an
employee can type in a client# or client name to pull up that client's
information. Can this be accomplished by a macro? Also I have three
seperate tables of client information based on the type of client they are.

 

[Steve Schapel]

Erin,

I'm creating a database for many users to access. I want a feature where an
employee can type in a client# or client name to pull up that client's
information. Can this be accomplished by a macro?

Yes, you can put an unbound textbox or combobox on a form, where the
employee can enter the client, and then a macro will use the OpenForm
action to open the client data form, and in the Where Condition argument
of the OpenForm macro, you use something like this...
[ClientID]=[Forms]![NameOfSearchForm]![NameOfCombobox]

By the way, if you mean that you have a field called client#, I would
point out that it is not a good idea to use a # as part of the name of a
field or control.

Also I have three
seperate tables of client information based on the type of client they are.

This is a bad idea, and I would urge you to change this design. Put
them all in one table, and if necessary add another field for ClientType.