KaylaHansa
New member
- Local time
- Yesterday, 23:37
- Joined
- Mar 22, 2020
- Messages
- 18
I have non-updateable list created from a union query. It is a list of customers and all the different systems they have (alarm, camera, network, ect) It looks like this:
Customer 1, System A
Customer 1, System B
Customer 2, System A
Customer 2, System B
Customer 2, System C
Ect...
When you click the system, I want a dialog to open with more info about that system. I can make it open to the correct customer, but not to the exact system. For example, if I click on System B for Customer 2, it will open System A for Customer 2, since that is the first in the list. I tried changing it around but now Access asks for a parameter when I click it. This is my code:
ItemID is from the union query. I'm assuming it doesn't work because Access can't find the related customer to the system because the union query loses the source tables. Does anyone know a way around this? Thanks in advance!
Customer 1, System A
Customer 1, System B
Customer 2, System A
Customer 2, System B
Customer 2, System C
Ect...
When you click the system, I want a dialog to open with more info about that system. I can make it open to the correct customer, but not to the exact system. For example, if I click on System B for Customer 2, it will open System A for Customer 2, since that is the first in the list. I tried changing it around but now Access asks for a parameter when I click it. This is my code:
Code:
DoCmd.OpenForm "ActivateAlarmDashboard", , , "AlarmID = " & [Forms]![Dashboard].PendingCustomersList.Form.ItemID, , acDialog, [Forms]![Dashboard].PendingCustomersList.Form.ItemID
ItemID is from the union query. I'm assuming it doesn't work because Access can't find the related customer to the system because the union query loses the source tables. Does anyone know a way around this? Thanks in advance!