Form Links

[dan.cawthorne]

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

 

[Amy Moody]

If I am understanding you correctly, you want to create a search function
that will display the enquiries based upon data that you either enter or
chose from a listing... is that correct?

Amy

 

[dan.cawthorne]

Well Im not Quite Sure if Its a Search Function It Quite Maybe!

Lets Say

I Open Suppliers Form Go To the Required Company.
Then I decide i want to Send that Company an Enquiry

So Then I Click Enquiry Button Which Opens The Enquiry Form, Which I a
Can Select Project Details, Return Dates Etc (This Form is Used to
View or Create Enquirys for this Particular Company)

But what i want to Happen is, With out Having to Retype the Company
Details With in the Company Detail Fields

They are already Brought forward from the Supplier form. But When I
Open The Enquiry Form, It Opens on a Blank record.

This Works If a Create a Enquiry Subform and Paste the Form on a
Second Tab on The Main Supplier.

 

[Amy Moody via AccessMonster.com]

Sorry for the delay in the response - was on vacation.
Okay, so when you select a company to send an inquiry to, you want the
company information already filled in for you....

There are a couple of ways to achieve this (I think). Using a filter when
you open the inquiry form is probably going to be the easiest. If you only
had one or two fields you want automatically filled out, going to the
Properties, Data, section of each field and under default value pointing it
to the previous form & control would do the trick. ie: =[Forms]![PreviousForm]
![CustomerName] - this will pull the customer name from the previous form and
place into the Customer Name field on the inquiry form.
This is the simpliest way to accomplish what you want....I think, I hope...
grin

Have a great day!
Amy

Well Im not Quite Sure if Its a Search Function It Quite Maybe!

Lets Say

I Open Suppliers Form Go To the Required Company.
Then I decide i want to Send that Company an Enquiry

So Then I Click Enquiry Button Which Opens The Enquiry Form, Which I a
Can Select Project Details, Return Dates Etc (This Form is Used to
View or Create Enquirys for this Particular Company)

But what i want to Happen is, With out Having to Retype the Company
Details With in the Company Detail Fields

They are already Brought forward from the Supplier form. But When I
Open The Enquiry Form, It Opens on a Blank record.

This Works If a Create a Enquiry Subform and Paste the Form on a
Second Tab on The Main Supplier.

If I am understanding you correctly, you want to create a search function
that will display the enquiries based upon data that you either enter or

[quoted text clipped - 40 lines]