D
drrajnishpatel via AccessMonster.com
Respected Masters, (Access),
I am a novoice in Access trying to learn the tpic , 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
tbl2= tbl2ID,1,,6,7,8,9,10.
tbl3= tbl3id,1,11,12,13,14,15.
frm1= 1,2,3,4,5,, +button that opens frm2 with 1,2,3,,6,7,8,9,10. second
button that opens form3 with 1,2,3,4,5,11,12,13,14,15... 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.....
I am a novoice in Access trying to learn the tpic , 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
tbl2= tbl2ID,1,,6,7,8,9,10.
tbl3= tbl3id,1,11,12,13,14,15.
frm1= 1,2,3,4,5,, +button that opens frm2 with 1,2,3,,6,7,8,9,10. second
button that opens form3 with 1,2,3,4,5,11,12,13,14,15... 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.....