On Wed, 31 Dec 2008 09:06:01 -0800, mike
wrote:

-i imagine i have to use VBA something like

Private Sub cboSubject_click
MessageDialogBox.show("Confirm entry")
if yes, then add record to table w/ selected item in both cbo's
else, reset cbo's w/out writing a new record
End Sub

I'd actually use the Form's BeforeUpdate event.

HOWEVER...

in my experience this kind of confirmation really ends up being an annoyance.
Users will get to the point that they thoughtlessly just choose OK (and then
ask you to fix up the damage they've done), and it will just waste their time.
"Yes, I wanted to make an entry, that's why I opened the blasted form!!!"
--

John W. Vinson [MVP]