access form won't update while combobox is being edited, must move to next record

Question

I have a continuous form with a list of comboboxes, pic here:

enter image description here

As you can see there is a small pencil on the left side of the access form to display that the current record in the form is being edited. I need to change this to a triangle so the other forms update properly with a button. Is there VBA to "lose focus" or change the pencil to a black triangle? I tried move to next record but for some strange reason it crashed. In addition it was fairly complex because I had to add logic if the user was on the last record, since it would throw an error because it can't go to next record on the last record. My vba is below (currently crashes access for some reason)

with recordset
if .recordcount=1 then
docmd.gotorecord record:=acfirst

elseif .absoluteposition = .recordcount - 1 then
docmd.gotorecord record:=acprevious
docmd.gotorecord record:=acnext
else
docmd.gotorecord record:=acnext
docmd.gotorecord record:=acprevious
end if
end with
end sub

Fionnuala Fionnuala · Accepted Answer · 2014-08-06T15:23:12

The usual way is to save:

 If Me.Dirty Then
     Me.Dirty = False
 End If

Pick a suitable event.

If Access is crashing, it usually means you need to back-up, compact and repair, and decompile.

access form won't update while combobox is being edited, must move to next record

1 Answers