Hi All,

I Was Woundering if some one could Help Me, With this rather Simple
Problem I Have.

I Have 2 Tables

"tbl_Suppliers" and "tbl_Enquirys"

Ive Managed to Achieve What i want When I Use A Tab Form and Insert a
Subform on the Second Tab.

What I want Is To Achieve the Same Thing With out using Tabs.

So Here Goes

Table "tbl_suppliers"
has some of following Fields "Company Name" , "Contact Name" And
"Address" and so on.

Tble "tbl_Enquiry" has some of the following Fields "Company Name" ,
"Contact Name" , "address" and "project Name" and etc

Ive Created 2 Seperate Form for each Table to Show each Data.

Ive Linked the two Tables in the Relationship Manager and Selected
Opton 1 in The Join Type and ive Matched the correct Fields together.

The Purpose
Its To enable Me to Store and Create Enquirys of Each Supplier With in
the "tbl_suppliers"
and then the Enquirys are stored in the Enquiry Table.

So I Want to be Able to Search or Filter to a perticular Company.
Which I can Do I.e "Readers ventilation"  Then I want to be able to
Click on a command Button Which opens the Enquiry Form showing Readers
Ventilation Already brought Forward. But Whats Happing is that the
form Opens Blank.

Does it make sense what ive wrote?

Regards

Dan