Need to have field values repeat on sub form

[montyb]

Greetings!

I have embedded a subform in a form, and would like a couple of field's values to repeat when a new record gets added. The values are coming from the parent form (basically a couple of ID fields relating back to the parent). How would I go about doing that?

thanks in advance

 

[JoeMiller]

In doing this kind of thing I take use of the default value property of a control and then set it to:

=[Forms]![MainFormName]![DesiredControlName]

You may need to issue a requery command on entry into the subform so that the updated values are carried down the the fields of your subform.

HTH Joe Miller
joe.miller@flotech.net