Customized search Function

A

Adrian1701

I have been developing a "simple" customer details database, which will be
most likley only ever used by myself, and mainly for producing mailings.

Not withstanding I have used this opportunity to learn the basics of Access
(I am using 97, company will not pay for upgrade!)

My request/question is pretty simple. I want to change the standard dialog
that is presented when you search for the database for a specific record,
effectly having a form whereby the company name can be entered and the open
form, with sub forms jumps to that record. The dialog just to have a text box
and a command button.

How do I achieve this, I am relativly new user to Access

Many thanks for any help
 
H

hagen31

How many fields do you want to perform your search on? Do you have a main
form with subforms that you want to perform the search on? How may tables do
you have?
 
J

John Vinson

I have been developing a "simple" customer details database, which will be
most likley only ever used by myself, and mainly for producing mailings.

Not withstanding I have used this opportunity to learn the basics of Access
(I am using 97, company will not pay for upgrade!)
Click to expand...

Not to worry. 97 is probably the best version MS ever released, and
it's quite capable.
My request/question is pretty simple. I want to change the standard dialog
that is presented when you search for the database for a specific record,
effectly having a form whereby the company name can be entered and the open
form, with sub forms jumps to that record. The dialog just to have a text box
and a command button.

How do I achieve this, I am relativly new user to Access
Click to expand...

There's no need to even have a command button!

Simply have a combo box, cboCompany, on your main form. It should be
unbound - nothing in its Control Source; its Bound Column should be
the CompanyID. Have a Subform on the form with its Master Link Field
set to [cboCompany], and its Child Link Field to [CompanyID].

John W. Vinson[MVP]
 
Top