possible to simulate pressing of key with VBA code?

Is this possible??
When a field is double-clicked, i want the field (combobox) to be
updated first and then start a procedure.
I have a combobox, 2 collumns, ID and name.
I want this for the following reason: when the combobox has already
data and i erase the name with the delete key, i want the combobox
data cleared (name is already cleared, id has to be cleared) when i
double click on the box. I tried it with setfocus on another field but
it doesn't work.

Toine

To clear the selected record in a combobox, set it to Null:

Me.cboNames = Null

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"A.J.M. van Rijthoven" wrote in message
...
Is this possible??
When a field is double-clicked, i want the field (combobox) to be
updated first and then start a procedure.
I have a combobox, 2 collumns, ID and name.
I want this for the following reason: when the combobox has already
data and i erase the name with the delete key, i want the combobox
data cleared (name is already cleared, id has to be cleared) when i
double click on the box. I tried it with setfocus on another field but
it doesn't work.

Toine

The problem is that i want to clear the record only when the data in
the selected records is cleared with the delete or backspace key. and
when directly after that someone soubleclicks in the combobox. The
problem is that the combobox data is not updated yet because the
record still has the focus...
When the selected record contains data when it is double clicked, a
screen opens to alter the data.
When the text in the selected record is cleared with the delete or
backspace key, a screen opens with the possibility to add a new record
to the combobox.

On Sat, 13 Aug 2005 07:25:38 -0400, "Douglas J. Steele"
wrote:

To clear the selected record in a combobox, set it to Null:

Me.cboNames = Null