Form controls

[jamesd]

I have a form that gets one piece of date from another form
text box=[Forms]![frm_loginandnextcount]![logonid]

How can I make this data wright to the underliying table

 

[SydneyGeek]

When you save the record (the BeforeUpdate event of the form), put in code like:

Me.[My field name]=Me.[My text box]

You could also set the save routine to only write the value for a new record:

If Me.NewRecord Then
    Me.[My field name]=Me.[My text box]
End If

Denis

 

[jamesd]

Thanks , that's what i tried but it simply will not work .
Any ideas

 

[SydneyGeek]

Have you displayed the other field to see if it has data?
And, if you are expecting the calculated text box to show the data from that field, it won't. It's an unbound control, with an expression pointed at a different data source.

Denis