I have two queries,and reports based on these, where I have inserted [] symbols in respective event criteria fields to allow me to select varoius events in the reports via a message box. This works fine. As I now have added numerous events it is becoming more difficult to remember the events and spelling of each event. Is there any easy way to provide something like a list of events with the message box?

Note: I already have a tbl of events which is used to provide data to various combo's. If I could use data from there I would have a ready made source to "jog my memory".

I have tried;
[Forms]![MyForm]![MyCombo]
substituting "MyForm" with my own form name and "MyCombo" with my form's combo name. The msg box still only asks for a parameter, unfortunately no list. The event combo I have is on a sub form, will that change anything when refering to it?

The expression builder supplies them, but is only available in VBA on 97 & 03.

llkhoutx
Thank you for your reply.
What do you refer to when you say "Them"?

What do you refer to when you say "Them"?

I mean to say that a complete list of program objects and properties of those objects.

When on the main form and referring to a control on the main for use

Me!dblw. There's no need to specify Forms![frmdetail]!dblW.

When on the main form and referring to a control on the subform use

Forms![frmdetail]![sfrmDetail].Form![dblW]

or

Me![sfrmDetail].Form![dblW]

When on the subform and referencing a control on the subform use

me!dblW.

The expression builder will build lines of code such as the foregoing. IN A2k and A02, I sometime open a new query and use the expression builder in the criteria line to get what I want,

The form containing the combo MUST be open at the time you run the query. You would select an entry from the combo, THEN press a button or something to run the query/report.

Arr Ha.

I have not had the form containing the combo opened.
Thank you for your assistance.:)