I volunteered to edit a database to add/edit the wish list from the user since the person who developed the db has moved on. The db was set up differently than I would have done it. May not be the right approach, but have decided to pull out the relevant objects into a new file and go from there. I wanted to use the FAYT as found at https://www.access-programmers.co.uk/forums/showthread.php?t=304997&highlight=fayt
It works well for finding items already there. I tried to add a not in list event and when I did, I wasn't sure how to refresh/requery the combo, as after the entry form was closed, the combo box was empty. I then removed the not inlist code and instead added a button to open the entry form, seeing if it would do any different and same result. In the code on the entry form at the end I put in the following.
I tried both to see if that would cover it and neither allows the display of the new data until I either close/reopen or go to design view and back to form view. Is there something different I need to do?
Employees form is bound, form to Add New Records is unbound and uses a recordset (AddNew/Update) to append the data.
It works well for finding items already there. I tried to add a not in list event and when I did, I wasn't sure how to refresh/requery the combo, as after the entry form was closed, the combo box was empty. I then removed the not inlist code and instead added a button to open the entry form, seeing if it would do any different and same result. In the code on the entry form at the end I put in the following.
Code:
Forms!frm_dt_employees.Requery
Forms!frm_dt_employees.cboNameSearch.Requery
I tried both to see if that would cover it and neither allows the display of the new data until I either close/reopen or go to design view and back to form view. Is there something different I need to do?
Employees form is bound, form to Add New Records is unbound and uses a recordset (AddNew/Update) to append the data.