input

[jattman]

i have a query which has as its criteria 'membership number'.

i want to run this query from several different forms and instead of typing in the membership number every time, i want the query to automatically select the membership number, from the record that i am viewing.

I have some knowledge of VB and would appreciate much is someone could help. THanks in advance.

 

[eggy168]

Did you try to put a macro or vb? You can try to put all the queries you need to run into a macro so when the first query runs, the marco kicks in and the rest of the queries will run automatically instead of typing the 'memerbership' in every query.

 

[jattman]

no i havent run it through a macro, i havent done it through vb either, because i dont know where to start.

and its one query, which i want to run from several different places, so i dont think a macro is the solution.

In some forms, the query result is shown as a sub-form and in others it run from a command button. (if it makes any difference)

thanks