Advice Needed: CheckBox control/field not updating last selected 2

[rafe]

I've got this limping along but you may know a better way.

Senario:
I have a continuous form with only one active control in the detail section, a CheckBox to select documents for further processing. Access 2K.

Problem:
The last record selected via a CheckBox control click is not updated until I move off of the selected record or I requery the whole form.

Here are a few things that I've tried.
1) Sub MyCheckBox_AfterUpdate()
Me.AnotherControlInHeaderSection.SetFocus
End Sub
2) Sub MyCheckBox_AfterUpdate()
Me.DummyControlInDetailSection.SetFocus
End Sub
3) Moving to anther record programmatically with DoCmd.GotoRecord... this works except if there is only one record in the list.
4) Me.Requery... This actually works but there's got to be a more direct way.

If you've got some ideas about how to do it better or why Access can't do it better, chime in.

rafe

 

[DougP]

Try saving the record.

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[rafe]

Like a charm!

Thank you!

 

[ednz]

Earlier posts were helpful (as in the need to save record)

for Access97 and 2000 use

RunCommand acCmdSaveRecord

instead

Ed

 

[rafe]

Ed,

I like the change. A more compact notation though functionally the same. I've made the replacement.

'DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

DoCmd.RunCommand acCmdSaveRecord

Thank you both.