tabbed form becomes blank on form view

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.
 
J

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
 
H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top