calling query from several different forms using generic form base

D

Daniel Jacobs

I want to write a query whose parameters are provided by the current record
of a form (datasheet format). The query would be able to be invoked from
several forms so I don't want to hardcode the for/page name.

Each of the forms that would invoke the query are subdivided into pages
(each containing a sub form). So, I presume that the parameter for a surname
(say) control on the form/page would look something like
CurrentFormName!CurrentPageName!CurrentRecord!surname.

Can this be done?
 
M

msnews.microsoft.com

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

form from query 2
How to make a sum of a sub-form on the main form 2
Form and Query used for report 5
Using a Query as a Form Filter... 5
Form based on parameter query only showing one record at a time 1
Print a report from a form based on a query 4
Fields in Main Form to Populate Records in Child Form 1
one query from two different forms (different Parameters) 6

Top