No way to have "event" action for query... right?

[Mel]

Often I create a query and corrosponding Form (in data sheet view)

I then create a Double Click Event for one of the fields

That opens a traditional form showing all the records fields.

For instance a list of Accounts and Names.

Double click the Account to open a form to see the entire Account
record... or whatever.

Is there any way to do this without creating the form?

We need the query as we use it to select appropriate data.

thanks for any help.

Mel

 

[RBear3]

You can actually base the form off of an SQL statement, and not need to have
a saved query. In the form's data tab, just paste the query SQL into the
record source field.

I don't believe you can use events in queries. Pretty much all interactive
user functions should be done in a form, so those features are all reserved
for forms.

 

[Arvin Meyer [MVP]]

Sorry, no. Code runs only in forms or reports, or can be called from an
autoexec macro from a module.

 

[David Cox]

You could create a one query database linked to your tables and have the
query run by the autoexec macro, and thus run the query by double clicking
on a shortcut on the desktop.

Not a recommendation ....