updating a field in a linked form

[brian30]

i have the following scenario:

a parent form, and several linked forms. i get to the linked forms via command buttons. each linked form shares a field with the parent form (e.g. age). when i put in the value in the parent form (for age), the linked forms don't show the value in the respective fields (i.e. in the age fields in the linked forms).

I've tried dlookup in an after event procedure but that isn't working. i've also tried dlookup in the default value setting.

should i be using dlookup or is there another function that will do the trick?

brian thomas

 

[seaport]

If the underlying tables of these forms are related (in the relationship diagram), the data should show up in the linked form.

However, you may try the "OpenArgs" parameter of the "Openform" method. With "OpenArgs", the linked form can get data from the parent form when the linked form is open.

Seaport

 

[brian30]

thanks for the advice. i'm not had much luck yet though. do you have any lines of code to share? perhaps that will make things clearer.

brian thomas