Brianwarnock
Retired
- Local time
- Today, 03:19
- Joined
- Jun 2, 2003
- Messages
- 12,701
Should I only insert data from the form view?
Yes, always insert data to tables from a form as that is the place where one can do all the clever formatting, validation, use dropdown lists etc. In the same way all reports are based on queries from the tables rather than the tables themselves, infact the tables sit out of sight as data repositories and access to them is by other objects.
Yes you need an after update event for each text box you wish to capitalise.
Brian
You could probably do them all in the Forms afterupdate event, the difference would be that you would not see any change until after the form was saved or lost focus ie you moved off that form and then back again.
Last edited: