unbound selection

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

"Lapchien" wrote in message
...
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

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


"Nikos Yannacopoulos" wrote in message
...
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

"Lapchien" wrote in message
...
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,

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

"Lapchien" wrote in message
...
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


"Nikos Yannacopoulos" wrote in message
...
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

"Lapchien" wrote in message
...
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