Hi All
I have a form that I use to search and modify asset info. If I for example search for the asset 01234567, the form is populated with the current table entry for that number. Is what I want to do is add a button to the form that when clicked will run a query and then show a history report based on the number in the asset field. I have created reports before that will ask for the asset number before creating the report but I don't want it to ask, I just want it to use the number already searched for in the form.
Any help appreciated.
Iann
I have a form that I use to search and modify asset info. If I for example search for the asset 01234567, the form is populated with the current table entry for that number. Is what I want to do is add a button to the form that when clicked will run a query and then show a history report based on the number in the asset field. I have created reports before that will ask for the asset number before creating the report but I don't want it to ask, I just want it to use the number already searched for in the form.
Any help appreciated.
Iann