Solved Subform data to display in main form

[silentwolf]

Hi guys,

I am not sure if this is possible.

Following situation.

I got Contacts with different Adresses therefore I have those adresses in a seperate table and a link Table for the AddressTyp.

In the main form I have currently a page Control and on one page there are all Conctact related Addresses shown.


However what I would like to do is to display the "Billing Address" in the Main form. so it does look kind of it does belong to the "Contact Data" of the main form.
with the other Contact related fields such as Contact Emails and so on.


Hope that makes any sense...

Thanks for any suggestion

Cheers

Albert

 

[bob fitz]

Can you post a copy of the db

 

[CJ_London]

just create another subform on your main form with a recordsource with criteria to limit the addresses to 'billing' - and ensure the linkchild and linkmaster properties are populated with customerID/whatever

depending on where you want to edit the data you may want to modify the recordsource of your contacts subform to exclude billing

 

[silentwolf]

Sure can,

thanks for taking a look at it.

Cheers

 

[silentwolf]

just create another subform on your main form with a recordsource with criteria to limit the addresses to 'billing' - and ensure the linkchild and linkmaster properties are populated with customerID/whatever

depending on where you want to edit the data you may want to modify the recordsource of your contacts subform to exclude billing

Hi,

thanks for your reply!
Well I do have a qryContactBillingAddresses where I limit the "billing Address"

But can't seam to get it like fields in the "mainform"

I did try with a single Form but no luck as yet.
It looks exactly like the continious form even when I checked in the Property Sheet and it is set to Single Form.

But I will try again maybe I overlooked something.

 

[silentwolf]

I managed the first step.

There was the subform still in the "Table" ..

Getting there many thanks for your help and should be able to work it out now

Cheers

 

[CJ_London]

not particularly tidy, but this is what I was suggesting

 

[silentwolf]

Hi thanks for your reply and yes I got it sorted It looks about like that below