recall details in subform

  • Thread starter drrajnishpatel via AccessMonster.com
  • Start date
D

drrajnishpatel via AccessMonster.com

Respected Masters, (Access),

I am a trying to create a database , i have run to the wall
with this, i have a problem, i want a few details entered in a form1 (tbl1)
to appear in the form2 (that contains full detils from tbl2 and few details
from tbl1) similarly ON FORM 3 i want full details from table 3 and again the
same few detials from tbl1.... for ex.
tbl1 = tbl1ID,1,2,3,4,5 Columns with details
tbl2= tbl2ID,1,,6,7,8,9,10.Columns with details
tbl3= tbl3id,1,11,12,13,14,15.Columns with details
frm1= 1,2,3,4,5,, +button that opens frm2 with 1,2,3,,6,7,8,9,10.(Column
details) second
button that opens form3 with 1,2,3,4,5,11,12,13,14,15.(Column details).. like
wise for many
forms.

i tried to create Query from tbl1 & tbl2,then base a form on Query_tbl1_tbl2,
but this didnt work the form simply went blank.....
 

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

Similar Threads


Top