You need the PARAMETERS statement. Check it out in F1 help. But it is a
simple "value for symbol" replacement, it does not have any of the
snazzy features that you described for the @prompt statement. Those
could be obtained, if necessary, by coding a form with a suitable
textbox, listbox, or other suitable Access item.

PS: better to have replied in the original thread. Usnet is "threaded"
- there's no guarantee that the peoplke who read your previous thread,
will also read the second thread.

HTH,
TC