policechiefwiggum
Programmer
Hi All,
I have a linked table that pulls a load of data from an SQL server, i then have a query that filters this data and that query is used as the rowsource for a list box.
I then have another linked table that connects to a SharePoint list. This list has a query that takes the ID of the selected item in the listbox, and then selects a related document from the SharePoint list.
What i want to do, is set the result of the 2nd (SharePoint) query as the value of a text box.
The SharePoint query will need to fire and the value of the text box will need to change each time a record is selected in the list box.
I've tried me.text2.controlsource = query1 but this gives me a #Name? error
Any ideas is appreciated.
Thanks
Pete
I have a linked table that pulls a load of data from an SQL server, i then have a query that filters this data and that query is used as the rowsource for a list box.
I then have another linked table that connects to a SharePoint list. This list has a query that takes the ID of the selected item in the listbox, and then selects a related document from the SharePoint list.
What i want to do, is set the result of the 2nd (SharePoint) query as the value of a text box.
The SharePoint query will need to fire and the value of the text box will need to change each time a record is selected in the list box.
I've tried me.text2.controlsource = query1 but this gives me a #Name? error
Any ideas is appreciated.
Thanks
Pete