I have created a macro, but can't seem to get it working. Could someone tell me what I've done wrong? Here's the details:
Access 2000. I have a switchboard that I need a lookup value on (my boss INSISTS on this). So, on the switchboard swbSPACES, I created a combo box which gets its information from qrySPACES DWGS. Here's what I have as the macro:
Open Query: qrySPACES DWGS
Apply Filter: filter name: qrySPACES DWGS
where: [qrySPACE DWGS]![SPACE NAME]=[Forms]![swbSPACES]![space name]
So I went to my form swbSPACES and on the combo box, space name, I changed the properties to the event: on change and saved the form. When I open the form and click on the combo box, the space names are listed and I can choose one, but nothing happens from there. Can anyone help?
I think I misunderstood you before, the query should point to the control that contains the item to be queried, which is another control from the combobox that is using the query as a lookup. I attached an example.