Form-Subform Referencing

[indyaries]

Greetings,

I need to have something that happens on a tabbed subform to change the value of a textbox on the main form.
*********************************************************
MainForm = f_Employees
MainForm textbox = txtCount

Tabbed Subform = fSub_Personnel_Actions_subform_2
Tabbed Subform Combobox = cboAction
Tabbed Subform textbox = txtDateCompleted
*********************************************************
On the tabbed subform, if the user selects DEPARTURE in the control cboAction AND if the control txtDateCompleted is not null, then I need the control txtCount to be changed from YES to NO.

For this to work as needed, those two criteria on the tabbed subform must exist -- cboAction must be DEPARTURE, and txtDateCompleted must have a date input, then the txtCount must be changed to No.

Any suggestions will be appreciated.

Regards,

Bob in Indy

 

[Rolliee]

forms![MainForm]![SomeField2] = forms![MainForm]![SubForm]!SomeField1


This should be done on an event.

Rollie E

 

[indyaries]

Rollie, thanks for responding.

I apologize for not explaining myself very well.

There are two criteria that must occur before the COUNT field is changed from YES to NO;
1. The cboAction selected must be DEPARTURE
2. The txtDateCompleted cannot be Null (must have a date input).

So, on the tabbed subform, I suppose something would need to check that both criteria exist before changing the value of the txtCOUNT field on the main form. I just don't know how I would go about getting this accomplished.

TIA !!

Bob in Indy

 

[Rolliee]

You might have a NEXT button that checked to see that both were done and then did the next action.


Rollie E

P.S. 200 miles east of Indy