Unanswered: Storing Entered Criteria for multiple queries
is there a way to store what a user enters in a pop up box for use in multiple fields? what i have is a query with 2 different tables. i put a [pop up box] as the criteria for a field and would like to use what the user enters to search through both tables since both have the same field available in each, but different values in their remaining fields. im using Access XP. if it involves writing a small VB script could you walk me through that, as im not too familar w/ using VB inside of Access.