autopopulate fk

[short]

I have a form that has tabs to view different information, the information
viewed is all tables, that I've made so the user can not edit any information
from those tables w/out clicking add new. So I create another form, that
opens when the add new is clicked. I want to know how to autopopulate the fk
for the linked tables in the smaller forms.
for example:
tblserver
id-pk

tbldiskdrive
id-pk
serverid-fk

do I link the forms by the Before Insert event, and how would that look.

 

[Roger Carlson]

If you use a subform control, it will automatically populate the foreign key
value.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[short]

That's not what I need. If I did a subform, it would make my form very
confusing for the users.

 

[Roger Carlson]

Okay. Another idea is to use the OpenArgs parameter of the OpenForm method
to send the value of your primary key to the new form. On my website
(www.rogersaccesslibrary.com), is a small Access database sample called
"OpenArgs.mdb" which illustrates how to do this. You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=307

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[short]

Thanks.

Okay. Another idea is to use the OpenArgs parameter of the OpenForm method
to send the value of your primary key to the new form. On my website
(www.rogersaccesslibrary.com), is a small Access database sample called
"OpenArgs.mdb" which illustrates how to do this. You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=307

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L