View Single Post
  #6 (permalink)  
Old August 6th, 2004, 05:01 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
Default

Error 91 is a VBA error, not a Jet SQL error. Do you have a second form designed with the 4 appropriately named textboxes, and a form name that you are using as the name argument of the DoCmd.OpenForm method, like:

DoCmd.OpenForm "YourFormName", acNormal, , strWhere

is your code breaking on this line? This is generic stuff and will run on any version of Access.

Bob



Reply With Quote