Greetings ~
I am currently duplicating in Access a program I wrote in Excel.
One of the features in the Excel program is that users can select an item from a combobox click 'go' and the resulting filtered data is loaded into a listbox
The user can then select one of the records in the listbox, then select an item from a combobox to edit that record.
Let's say the record selected in the listbox showed 'Unapproved' in the field labeled 'Status'.
If the user selected 'Approved' in the combobox then clicked the Edit button it would find the selected record in the Excel database and change that attribute from 'Unapproved' to 'Approved'
I am able to load my records into the listbox using many filters, now I am wondering how to allow users to select and edit the record like they can in my Excel program
Thank You in advance