Subform Problem

[Guest]

Hi There

Can any one help?

I have a main form which has two combo boxes on it used to select data
(either first name or last name) I then have a subform on the main form which
I want the records to be dispalyed, based on the data entered in the main
form (ie. display all records with either the selected first name or selected
last name)

I can not link the main and subform as the main form is unbound.

What is the best way for me to set this up?

Any help would be much appreciated.

 

[Guest]

Hi Bella

1st I would bind the main form to the table that contains the names you are
looking for. Use the properties box data column and select the table from
the drop down.

Next, it is a bad idea to search for a record by a non unique string (such
as 1st name or last name). Use the wizard to create a "find a record on this
form" combo and ensure you select the primary field for the record and the
1st name and last name fields from the options that the wizards offer you.
This way you will be able to use the combo and see both the ID, 1st name and
last name all together on the smae row so you will have a better idea of who
you are looking at.

A large DB that I look after also displays the postcode (zipcode) as there
are many pople with the same names.

Hope this helps


--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.