I've created a problem tracking database that is very simple. Within it is a form that tracks how many open problems are assigned to a particular technician.
I also created a form that allows you to open up the entire entry for editing etc.
The problem is that I want to create a button on the first form that will open the 2nd form with only the records assigned to that technician.
In form design I click the "Button" button and pick Form Operations - Open Form, Next, Pick the form I want (frm_open_by_), click the "Open the form and find specific data to display.", Next, Highlight Tech Assigned on both sides and hit the <-> button and finish it off...
See below for the code that the Macro gave me:
(Action Open Form)
Form Name: frm_open_by_
View: Form
Filter Name: (blank)
Where Condition: "[Tech Assigned]=" & "'" & [Tech Assigned] & "'"
Data Mode: (blank)
Window Mode: Normal
The macro works great, except it opens up ALL the records, not just the ones assigned to Jane Doe or John Doe or whomever. . .
Thoughts, solutions? It's been giving me fits.