Connecting Tech Pros Worldwide Help | Site Map

Active Form as Query Criteria

  #1  
Old November 13th, 2005, 08:52 AM
Pooya
Guest
 
Posts: n/a
Hi Everyone,

I have tried searching for the answer in this newsgroup, but I don't
think I have found an answer that works for me.

I have several forms that are populated by the same query however
criteria of the query which refers to a project id needs to be
dynamically populated with the active form name like so:

Criteria: Forms!ACTIVEFORMNAME!Project_Id

I have tried :

Criteria: Forms!Screen.Activeform!Project_Id

but that did not work.

Any help or guidance would be appreciated.

Pooya
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Apply a filter to a Union Query jmarcrum answers 6 February 6th, 2008 04:34 PM
searching using text box and query DP answers 11 February 26th, 2006 11:15 AM
filling fields with query results Brian answers 6 November 13th, 2005 11:26 AM
MS Access calendar 9.0 to pick dates on a form Matthew answers 3 November 13th, 2005 06:17 AM