tabbed form becomes blank on form view

[Hugh self taught]

Hi clever people,

I have a tabbed form with data from a tblMain on the 1st tab. That's all
fine. I have address details in a tblBusAdr & tblpersAdr for business &
personal addresses since there will be multiple records for the same
addresses. My 2nd tab is where I want the address data to appear & although
there is relationships for PK & FK between the 3 tables my form detail goes
blank even though the fields show a valid source.

Am I trying to do something which is not possible or do I have to use a
subform on the tab?

If needed I can post the access generated code when I added the fields to
the 2nd tab from the tables.

 

[Jeanette Cunningham]

You would need a subform for the address details on the 2nd tab.
Set the link master and child fields to the PK for the person on the main
form.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Hugh self taught]

Hi Jeanette,

I realized my idiocy just after I posted the question, but in order to
achieve my objective I have to have 2 subforms on the same tab. One for the
Personal address table & one for the Business address table. I just need to
fiqure out how I will deal with new records etc for the parent.

Thanks for responding
Cheers for now