How do I verify data using another form and How i get the rest dat

L

loizos

Hi ,
I manage to verify the data using the relationship.
But how I will get the rest information of the verify record.

i .e

Verify field: Id No
How to get the Name and Last Name

Thanks
Loizos
 
R

Rick B

Take a look at the Northwinds order form. After selecting a vendor, the
address data fills in with the appropriate information and can't be changed.
The SHIPPING information fills in with the data as well, but can be changed
in case the items will be shipped to a different location *for this order
only*.

You can also take a look at how the orders subform works when a product is
selected.
 
L

loizos

Thank you Rick,

I Can not find the Nothwinds under Office folder.

What I will do?

Thanks
 
R

Rick B

depending on the version you are using, try these paths...

<Office path>\Office10\Samples\
<Office path>\Office11\Samples\

I think you can also open the Northwind database by selecting the HELP menu,
then "Sample Databases" then Northwind.

You can also do a search and find previous posts on how to pull in data from
another related table to your forms. The best way I have found to find
previous posts is to use google, then click "more >>", then select "Groups".
In the search box, enter something like "microsoft.public.access" followed
by your search terms. The following link has several responses that might
be useful to you...

http://groups.google.com/groups/sea...public.access+name+from+related+table+to+form

Hope that helps!
 
L

loizos

Hi again,

I study that form and I did not understand who it gets
Vendors Address.
I place in a form a text box and at the control source
i can choose only the fields from Order Table and not from
Vendors fields . Why?

Thanks
 
Top