You shouldn't (and can't) do what you want directly in a table.
Tables are for storing data, not interacting with. Stick with your form.
As well as redundant data an Age field is meaningless as it is only correct at the time of data entry. Age should be calculated from the date of birth and...
I found the best way was to actually dive in with a specific task in mind.
The real secret to success with a new thing like VBA is to break it down into very small steps.
So if you need to manoeuvre something around (like a time/date) do the basics in a query, use the QBE editor to select a...
By adding the wildcard to the beginning of your search string you are rendering the Index on either field useless.
Do you have to search in that way? Try it by removing the first wild card and I bet it speeds up considerably.
You have spaces in your field names, which is not a good idea. Welcome to bracket city, where you get to do extra typing for lots of no extra reward... ;)
Update [Outcome Master] SET [Appointment Date] = DateValue([Appointment Date])
Formatting the data does not change it, merely how you see it displayed.
If you really do want to delete the time information rather than simply querying it in the right fashion to get the results you want than as @jdraw suggested you will have to run a one-time update query.
From your description, I would suspect a network issue, above anything else, unless something has happened to increase the number of records by a factor of 10 or more.
Network traffic or more importantly a network "storm" can and will cause massive problems. Something somewhere might have ended...
Take a backup before doing anything.
Another route is to simply copy your entire database, in windows explorer. Call it NewFrontend
Delete all the tables.
Link all the tables back from your existing working copy.
You now have a front end database.
You can now safely delete all the objects...
Agree with everything @CJ_London has said.
With Azure AD the IP address issue should vanish. We have found that the connectivity isn't really an issue until you start moving between countries. Ping/response times are very good when connecting to a relatively local Azure Service, but for...
Rereading your post and thinking about it that won't work on a continuous form anyway, and not in the on open event of a form.
Simply use either a join in your underlying query to display the value or copy the combobox and control source, and simply display column 3, make the control locked to...