View Single Post
  #2 (permalink)  
Old August 5th, 2004, 05:44 PM
Bob Bedell Bob Bedell is offline
Friend of Wrox
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts

Set the forms WhereCondition argument when you open it like:

DoCmd.OpenForm "Form2", acNormal, , strWhere

Your strWhere variable will work fine with one modification. The WhereCondition argument takes a SQL Where clause without the word 'Where'. So earlier in your code change:

strWhere = "WHERE"


strWhere = ""



Reply With Quote