Auto Population

C

Chris

I have created two forms (one main and the other a sub)
and need two of the fields on the sub-form to be auto-
populated with two of the fields from the main form. For
example: I enter a music cd's artist and album into the
main form, click on the "sub-form button" to activate
tohe sub form, and the same two fields need to be
populated in the sub-form (yes, I realize this is very
redundant, but I need it to be). Any help would be
appreciated. My e-add is
(e-mail address removed) . Please put "Access" in
the subject. Thank you!!!!!!!! :)

-Chris
 
P

Pieter Wijnen

I Guess you don't mean a SubForm (Form on a Form) but a form that is opened
from the main-form
If it is a recordentry form
Set the Default Value Property of the controls to =MainForm!MainControl
otherwise (for unbound controls ) set the values in the form_open (or
Form_Current for continous forms):

Me.SubControl.value = Forms!MainForm.Value

HTH

Pieter
 

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