How do i display record data in a Form

[Maria D]

Hello, i need help with my form.

I have two tables, one (data table) that is just for inputting data
straight to the table and in that table i do have it set for my vendor as a
look up to the vendor table. My second table (vendor) contains cell, home
no., and fax no.

my problem: In the form: I want to be able to choose my vendor, and when i
choose that vendor(no problem choosing vendor) , i want it to display all the
phone numbers that are in my vendor table. how do i have it display the
record data?

Thank you.

 

[Jeff Boyce]

"How" depends on "what". What data are you storing in the vendor table and
in what structure?

Are you saying that you use multiple fields to show different vendor phone
numbers? If so, one approach might be to use a UNION query to return all
the phone number X vendor combinations you have...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Maria D]

i'm a little confused, let me explain myself how i set it up.

my vendor table has 5 fields (name, contact, phone, moble, fax). I also
have a data table - within this table i have that vendor field doing a lookup
to my vendor table. i was able to bring in the vendor into my form, but what
i can't get it to do is display me, the vendor info for that record. i can
use the drop down and see the different fields, but i want to display it on
the form without having to select it again.

does that make sense?

Thank you.

 

[Jeff Boyce]

Maria

So, how are you "picking a vendor"? From a combobox?

What data is the form bound to? ?The vendor table? If so, picking a vendor
could be used to display that vendor's data (e.g., phone numbers).

A bit more info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP