tabbed form becomes blank on form view

  • Thread starter Thread starter Hugh self taught
  • Start date Start date
H

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.
 
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
 
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
 
Back
Top