selecting a value for a form from the other form

[alpertunga65]

Hi

I have a form (formA) with a sub form (SubformB) in it. In this subform there is a field (Candidates) in which I want to write a value by using another form (FormC). Sub form and the other form have different source tables (TableB & TableC).

What I want to do is;

While FormA is open, by clicking the field (Candidates) on (SubformB), I want to open (FormC). This form is a Data sheet. Then again by clicking a checkbox on this form, I want to assign the value to the field (Candidates) on SubformB.


I need help

Thanks a lot...

 

[CJ_London]

Assuming form a with subform b is open then in the checkbox after update event in form c put the following

forma!formbcontrolname!form.candidates=me.candidates

where
forma is the name of form a
formbcontrolname is the name of your subfrom control for form b
candidates is the name of the control in your subform b
me.candidates is the name of your control n form c