GingGangGoo
Registered User.
- Local time
- Today, 15:43
- Joined
- Dec 14, 2010
- Messages
- 121
In my web app I have contact table / list for associates of my organization, staff, volunteers, clients. I need another table for a specific kind of contact, call these potential clients, some of whom will never be added to the associate table, but that I still need to track, some but not all of the data for these is the same. Now, when I want to add one of these "temporary folks" to my associate table, I think the way to do it is to add a macro to the list and/or datasheet view of the potential contacts table which opens the associate table list view and lets me add a new record. The macro I need help with would fill in the blank record where the data would be the same, i.e. firstname, last name, etc.
I realize that in Native Access, all of this would be accomplished using other means so that stuff wasn't stored twice, but in the web app, I am not able to use vba, or append table queries, etc.
Appreciate help here, I was starting to learn some vba but am not much knowledgeable on macros.
I realize that in Native Access, all of this would be accomplished using other means so that stuff wasn't stored twice, but in the web app, I am not able to use vba, or append table queries, etc.
Appreciate help here, I was starting to learn some vba but am not much knowledgeable on macros.