Enter parameter box

[gdonald20]

Hi

This might sound like a strange question but is there any vb code i can use
to hide an enter parameter box from the user automatically selecting the ok
option.

I have a continous form which is controlled by an unbound combo box. The
form has a field called comments but due to the cramped nature of the
continous form i have design a popup form that the user can access on double
click of the comments field.

But when i double click the comments field it asks me to enter one of the
form parameters. If the user leaves the box empty and presses ok the popup
loads correctly on the correct record. I just wanted to hide the box as it
looks messy and is another opportunity for the users to make an error.

Thanks for any help

Gillian

 

[Allen Browne]

No. There is no way to close a Parameter dialog like that.

Simplest possibility is to press Shift+F2 in the memo field.
This pops up the built-in Zoom box, and that's all you need.

If you don't like that, you could use an *unbound* form as the popup. In the
DblClick event of your memo field, open the form and copy the contents into
the big unbound text box in the popup form. Presumably that form has Ok and
Cancel buttons. Cancel just closes it, and Ok copies the info back to the
original field.

The third option is to avoid using parameters in the first place. Instead,
use the Filter of the form, or set its RecordSource so the form only has the
correct values (using a literal value in the SQL string.)