ACCESS FEED: Re: [MS_AccessPros] Form and subform not working

Kamis, 25 September 2014

Re: [MS_AccessPros] Form and subform not working - not display information well

May be this image will help

[image: Inline image 1]

On Thu, Sep 25, 2014 at 11:20 PM, muralles_r12@yahoo.com
[MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

>
>
> Hi guys, I hope you are well.
>
>
>
> I am back, working on access, but I am having trouble to get a simple job
> done.
>
> Can you help me out?
>
>
>
> I want to use a form and sub-form to display companies and its contacts.
>
>
>
> The form should display the company info
>
>
>
> The sub-form the contacts for the company
>
>
>
> I have the 3 tables
>
>
>
> vendors - primary key vendorID
>
> contacts - primary key contactID
>
> vendorContacts - primary key = vendorId and contactID
>
>
>
> I want to be able to add new contacts to the company right on the sub form.
>
>
>
> I build a query on the owners table to use it on the sub form.
>
>
>
> I build a query on the vendors and vendorContacts table to use it on the
> form.
>
>
>
> I want to embed the sub form into the form and set the master and child
> links.
>
> Why does this not work?
>
>
>
> Thank you.
>
>
>
> Jorge Muralles
>
>
>

[Non-text portions of this message have been removed]