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
Form and Query used for report 5
Dynamic Crosstab Form 5
Multiple Parameter Crosstab query filter by form 1
2007 Report from Form and Query 1
one query from two different forms (different Parameters) 6
Form that Runs a Query. 8
Combo Box Filtering between Forms 1

Top