garychamberland
Technical User
Hello all,
I’ve built a database for a local nonprofit that has to track several services they provide in order to compile reports for funding. To facilitate the data entry I’ve created a multi-tab form to enter data into the related tables. The main part ( area above the tabs ) of the form contains the most accessed client info ( name, address, etc….) the first tab contains the balance of the client table. The remaining tabs are for the many to one related tables for services provided, classes attended and child info. The tables all include the client name as at least part of their respective key fields.
My problem is twofold.
>When entering data, the most accurate way to enter the name field is to copy and paste into the respective tab’s name field. I haven’t been successful in creating a macro for when the field gets the focus and my expression building skills leave something to be desired. Any pointers?
>Upon entering the data in the name field for any of the tabs, I get the error message “This property is read-only and cant be set” after acknowledging the information message box, the name is entered and data entry resumes as it should. What am I missing?
Any information that you could provide would be much appreciated.
Sincere thanks in advance.
Gary C.
I’ve built a database for a local nonprofit that has to track several services they provide in order to compile reports for funding. To facilitate the data entry I’ve created a multi-tab form to enter data into the related tables. The main part ( area above the tabs ) of the form contains the most accessed client info ( name, address, etc….) the first tab contains the balance of the client table. The remaining tabs are for the many to one related tables for services provided, classes attended and child info. The tables all include the client name as at least part of their respective key fields.
My problem is twofold.
>When entering data, the most accurate way to enter the name field is to copy and paste into the respective tab’s name field. I haven’t been successful in creating a macro for when the field gets the focus and my expression building skills leave something to be desired. Any pointers?
>Upon entering the data in the name field for any of the tabs, I get the error message “This property is read-only and cant be set” after acknowledging the information message box, the name is entered and data entry resumes as it should. What am I missing?
Any information that you could provide would be much appreciated.
Sincere thanks in advance.
Gary C.