Popup Form Launched from SubForm Button and New Record Sync

[tbl]

A subform (continuous) has a button, repeated on each row,
to pop up a filtered (synchronised) form. When the popup
comes to a new record, I'd like it to sync with the record
on the subform that popped it up. But the subform is used
in several different main forms, so I'd like to avoid using
the main form's name in the code. I've tried naming the
subform directly, but can't seem to get a spark.

If Me.NewRecord then

Me![txtIvDetId]= Form![My-still open-Subform]![txtIvDetId]

End If


But I can't seem to make it work.

Any suggestions appreciated.

 

[Guest]

Look at the Access help for OpenArgs.

When you open the form with DoCmd.OpenForm, you can include avalue in the
7th argument. You can then use that value in your form/subform without having
to reference the calling form.

Steve

 

[tbl]

Look at the Access help for OpenArgs.

When you open the form with DoCmd.OpenForm, you can include avalue in the
7th argument. You can then use that value in your form/subform without having
to reference the calling form.

Steve

A subform (continuous) has a button, repeated on each row,
to pop up a filtered (synchronised) form. When the popup
comes to a new record, I'd like it to sync with the record
on the subform that popped it up. But the subform is used
in several different main forms, so I'd like to avoid using
the main form's name in the code. I've tried naming the
subform directly, but can't seem to get a spark.

If Me.NewRecord then

Me![txtIvDetId]= Form![My-still open-Subform]![txtIvDetId]

End If


But I can't seem to make it work.

Any suggestions appreciated.

Thanks Steve. That seems to work very well.