Updating a text box

[ds0203]

Greetings,

I have a form that has text boxes to enter in a permit number and description. There is then a subform that we list individial permit conditions. I would like to be able to type in the permit number on the main form and then have that number automatically entered into the permit number field on the sub-form. How do I do this?

Thanks!
ds

 

[JANR]

The linking properties of subforms is a good start. Add your mainform field to LinkingMasterfield and your subform field to Linking ChildField.

If the is is already a field there (as it should be) sepearate the fields with a semicolon.

LinkingMasterfield: PrimaryKey;YourField
LinkingChildField: ForeignKey;YourSubformField

The other way is by code in the after_update event of your field on the main field. Something like:

Me.NameOfSubformContainer!Me.NameOfField = Me.FieldOnMainForm

JR

 

[ds0203]

I already had the linking fields populated, so adding the code in the after update event worked great.

Thanks!!