Jass Saini
asked on
How to keep a memo displayed
Hello,
I have code that will write to my Memo box if there is a value in BC1 and so on. It will only display the text if I in a record that has BC1. I need to keep displaying after I click off the record so the user know that they entered something into the memo box
Here is my code
I have code that will write to my Memo box if there is a value in BC1 and so on. It will only display the text if I in a record that has BC1. I need to keep displaying after I click off the record so the user know that they entered something into the memo box
Here is my code
Private Sub Remarks1_AfterUpdate()
Dim rst As DAO.Recordset
Dim strRemarks As String
strRemarks = Me.Remarks1
If strRemarks = "" Then Exit Sub
Set rst = CurrentDb.OpenRecordset("Final_Table")
'strRemarks = Me.Remarks1
Do While Not rst.EOF
rst.Edit
If Nz(rst![BC1Chng1]) <> "" Then
rst![Remarks1] = strRemarks
Else
rst![Remarks1] = Null
End If
rst.Update
rst.MoveNext
Loop
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if I click off the record the Remarks1 field doesn't show what I just typed.I assume the Remarks field is a bound textbox (that is, the textbox has a ControlSource)? If so, then it would show the value from the Remarks field for each RECORD.
If you "show" the value you type in one field in the others, then Access will update the other records. Is that what you're after?
Regardless, the method I suggested would work, assuming you always want to have the "latest" data typed into Remarks.
Yes, "MyText" is a variable, created in the General Declarations section of your form.
ASKER
Thank You
ASKER
MyText ..is a variable???