unbound selection

  • Thread starter Thread starter Lapchien
  • Start date Start date
L

Lapchien

I'd like a command button, when pressed, to open a form based on the
contents of an unbound text box on a 'selection form'. So, for example, if
'15' was entered and the cmd button pressed, it would open form 15. Same
for other numbers too. Does this have to be a bound or unbound field?

Thanks,
Lap
 
Lap,

This is really addressing both this and your previous posting: I would use a
listbox instead, and use the Double Click event to open the selected form.
No additional text boxes requiring manual user entry, no command buttons.

HTH,
Nikos
 
Thanks - I'd like the user to press enter on the selection in the listbox -
but if I put this on the On Enter procedure I get an error when the form
initially opens...

Lap
 
Lap,

The On Enter event occurs when you enter the control (as opposed to On
Exit), not when you hit the Enter button. Is this what confused you?
If you don't want to use the double click, you could always leave it blank
and use an additional command button. Or, you could use the On Exit event,
in which case your code will be fired by hitting the enter key as a result
of moving focus to the next control, but the same will happen with hitting
the tab key or moving focus to another control with the mouse.

Nikos
 
Back
Top