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.

Is Tech Assigned a number or a text value? your code is assuming text and as text does not euwal number then no filter is applied.

David

__________________
www.xcraftlimited.co.uk The Home of Simple Software Solutions.

The Tech Assigned field is a text field not a number

Just before the macro runs type in the following

MsgBox "[Tech Assigned]=" & "'" & [Tech Assigned] & "'"

Does it give you what you would expect it to do?

It could be you need to use the Me! operator. Not used 2007 yet.

David

__________________
www.xcraftlimited.co.uk The Home of Simple Software Solutions.