I will attach the access file so that you can experiment etc.
The lesson form in the navigation form needs work, but I simply cannot find the right answers.
I have followed a guide on here, on how to make a dynamic search box, however, this seems to not work when the listbox is made using the 3rd option which allows me to select a record in the listbox, and it directs me to the correct record. If the listbox is made from the 1st option, the dynamic search box works fine. I need the listbox to be able to do both things.
Also, because of how my form refreshes after each data is input, my error message is not displaying properly. My index prevents the PupilUsername, Period/Time and Date being the same. As soon as one of these is not unique, I would like a custom message to pop up.
Can anyone help? Quite urgent.
The lesson form in the navigation form needs work, but I simply cannot find the right answers.
I have followed a guide on here, on how to make a dynamic search box, however, this seems to not work when the listbox is made using the 3rd option which allows me to select a record in the listbox, and it directs me to the correct record. If the listbox is made from the 1st option, the dynamic search box works fine. I need the listbox to be able to do both things.
Also, because of how my form refreshes after each data is input, my error message is not displaying properly. My index prevents the PupilUsername, Period/Time and Date being the same. As soon as one of these is not unique, I would like a custom message to pop up.
Can anyone help? Quite urgent.
Help on multiple issues in form
