ThinWhiteDude
Technical User
Using Access 2003:
I am trying to open a form from a listbox and having the devil of a time with the where condition.
This is in the OnClick for the listbox, which is one of many listboxes on the form. They all need the same code (thus the ActiveControl usage) –basically to open a report that matches the number clicked on in the box.
The NumID field is the only one I have in the list, built straight from the table.
The NumID field on the form I want to open is a text field.
Here’s what I have :
Any help you can give, I would greatly appreciate.
TWD
I am trying to open a form from a listbox and having the devil of a time with the where condition.
This is in the OnClick for the listbox, which is one of many listboxes on the form. They all need the same code (thus the ActiveControl usage) –basically to open a report that matches the number clicked on in the box.
The NumID field is the only one I have in the list, built straight from the table.
The NumID field on the form I want to open is a text field.
Here’s what I have :
Code:
DoCmd.OpenForm "frmEquipmentMalfunctionReport", acNormal, , "NumID=" & ActiveControl.Column(0)
TWD