Fill In Cell

[pbrown2]

Form and Subform:

I know it is redundant, but some managers want it.

There is a field in the subform:
Form: Paint
Form Field Name1: Text12
Form Field Name2: Text14

Subform Name: Paint Detail (on display)
Control Name: Paint Data
Subform Field Name 1: Text11
Subform Field Name 2: Text13

I need a way to have Text12 to be updated to match Text11 and Text14 to be updated to match Text13.
However the thing is that I need Text 12 & 14 to update in a table (Paint). Therefore, I don't think I can simply use Text11 & 13 as the control sources.

I have tried this on the After_Update on Text11 in the subform, but keep getting errors from.. can not find fields, mismatch type, to, can not find forms:

Dim Txt as String
Txt = Forms![Paint]![Paint Data].Form![Text11]
Me.Text12 = Txt

Please, any suggestions are welcomed an appreciated!

Thank you for any and all help,

PBrown

 

[databasesrus]

are you using access97?

 

[pbrown2]

Yes, Access 97

Thank you for any and all help,

PBrown

 

[databasesrus]

I'm not certain I understand exactly but I think I have the idea. Instead of control source, do an after update event for the Text11 and 13 similar to this. If they are on different forms you will have to specify the form

If Not IsNull(Text11) Then Me.Text12.Value = Me.Text11
If Not IsNull(Text13) Then Me.Text13.Value = Me.Text14

 

[pbrown2]

Thanks!
I did not think of that!
But I have an awful hard time with the form names and where to put them. If you would not mind could you help?

Text11 and Text13 are located in the subform Paint Detail which I have named Paint Data

Text12 and Text14 are located in the main form Paint

Once again thank you for the idea and help!



Thank you for any and all help,

PBrown