calling query from several different forms using generic form base

  • Thread starter Thread starter Daniel Jacobs
  • Start date Start date
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?
 
Back
Top