Update a record without moving to the next one

[louise]

Hello,


I have a form designed to assemble a three-part text-field "Course Label" , from two existing fields and one entered (a sequential numbering):
Part 1 A text field SEMTYPE created with a query (e.g., FSS- indicates Fall & Single Session)
Part 2 A field that is filled in with a number, COURSENUM, going down the form, assigning the numbers in sequence
Part 3 An asterisk or nothing ASTERISK

The result is a field labeled COURSECODE created by the "After Update" event of the COURSECODE field: SEMTYPE & COURSENUM*ASTERISK
The result would look, for ex., like FSS-1* or SS-5
So, when the user enters the COURSENUM ***and moves to the next record***, the course code is created and displayed for the previous record.

BUT the problem is that the user occasionally changes the COURSENUM field but doesn't move to the next field -- so the change is not made.
I have tried On Dirty but that doesn't work either.

I would appreciate any suggestions!
Thanks

[ItsMe]

I do not usually use it, but you might try the Refresh Method of the form. According to MSDN, if you change the data of an underlying recordsource via code or another user, the Refresh method will show the changes made by others.

Before you make changes using code, save the form with the Dirty property. Then use code to change the data in the table(s). Then try the Refresh method. The way I understand the Dirty property is that it's a property of the form and is looking at the changes made to its own Recordset, not changes in the table, itself.
https://msdn.microsoft.com/EN-US/lib.../ff836021.aspx

If the Refresh does not work, then you will need to do a requery. I usually use requery, however, you will need to use additional code to maintain the Current Record if you are using Single Form View.