#delete in combo boxes
#delete in combo boxes
(OP)
i have a form that deletes a record in a table. The user chooses the relevant record from a combo box, and then click a button that says delete record, once this process is done and the user returns back to the combo box where the record has been a deleted there is #deleted listed in the combo box, but if a user by mistake clicks this there is an horrible error message, what can i do to avoid this, what VBA code could i put in the after update method? please help!
RE: #delete in combo boxes
cboMyCombo.Requery
Actually, I had a problem with something like this not long ago, so I'm not sure this will work, but give it a try.
Rick Sprague
RE: #delete in combo boxes
but i am afraid this did not work, but the reason for this may be because when i created the combo box, access gives you an option to "look up values in a table/query", or the other option is to "find a record on my form based on the value i select in the combo box".
I took the latter option, therefore i think the requery will not work. Any further ideas?
Thanks
Kindi
RE: #delete in combo boxes
Cheers
Kindi