I need help.
I am new to MS Access and have been assign this project.
I want to be able to filter data from a form that will be displayed on a subform.
I don't know if this is possible but ideally i would like to double click on a field from Form A which will open a subform and display filtered data based on the data's site code that was double clicked.
My database is for a budget tracker
finance data will be entered for different sites. I would like an option for users to be able to click on a field in a form that will open another form so they can edit data which has been filtered for that site.