Form: ServerDetail
Table1: ServerDB
Table2: MasterAppList
Link: ServerName
I need to populate textbox or listbox with all matching records from MasterAppList based on ServerName, and have it update, everytime ServerName changes in the ServerDetail form.
NOTE: Not all servers have a record in the MasterAppList table, and some servers have multiple records.
I have a query that works for the initial record, but I don't know how to get it to update.
SELECT *
FROM MasterAppList
WHERE (([Forms]![ServerDetail].[ServerName])=[MasterAppList].[Server Name]);
I had a subform that would successfully accomplish this for the form view, but I have an external app that pulls data from this DB and it could not collect the data in the subform.
And, in case you can't tell yet, this is not my primary job function. So if you are able to offer any help, please use little words. ;^)
Thanks,
Bruce
Table1: ServerDB
Table2: MasterAppList
Link: ServerName
I need to populate textbox or listbox with all matching records from MasterAppList based on ServerName, and have it update, everytime ServerName changes in the ServerDetail form.
NOTE: Not all servers have a record in the MasterAppList table, and some servers have multiple records.
I have a query that works for the initial record, but I don't know how to get it to update.
SELECT *
FROM MasterAppList
WHERE (([Forms]![ServerDetail].[ServerName])=[MasterAppList].[Server Name]);
I had a subform that would successfully accomplish this for the form view, but I have an external app that pulls data from this DB and it could not collect the data in the subform.
And, in case you can't tell yet, this is not my primary job function. So if you are able to offer any help, please use little words. ;^)
Thanks,
Bruce