Setting DefaultValue in subform

[agibsonsw]

Hello. Access 2010.

I have main form for Events which opens a second form linked via EventID. This second form contains a subform. I want to set a DefaultValue for a field in the subform. It is actually for the value just in an adjacent field (of the subform).

I tried using OnCurrent for the subform, setting

Me.Text1.DefaultValue = """" & Me.TheOtherOne & """""

but no joy. Thanks, Andy

[HansV]

That's one " too many at the end.
If the values are numbers, you can omit the """"

[agibsonsw]

Hello and thanks @Hans.

I didn't have the extra quote in the original but it turns out it wasn't the default value anyway, Doh! The records were created on the first form.

Just chatting..
The value I needed for the default should have been read after joining four tables, but it is difficult when you have little time and someone sitting at your shoulder . To get it working I cheated: I used the AfterUpdate of a combobox to read two ID values on the form, store them in VBA variables and construct a DLOOKUP to extract the single value I needed. I always feel that this is cheating but, pragmatically, it works and is very straight-forward.

Regards, Andy.