possible to simulate pressing of <tab> key with VBA code?

  • Thread starter Thread starter A.J.M. van Rijthoven
  • Start date Start date
A

A.J.M. van Rijthoven

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
 
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.
 
Back
Top