New to VBA and DBs, a lot of background reading though.
I would like to develop a form for data entry that will input “Contact Details” into a “Contact Table”. This I find easy to understand if I am only creating one record at a time and the one record is input into an underlying table. However the challenge for me is that my form will need to show many different types of “Contacts”, for example “Owner”. “Architect”, ”Engineer”, ”Builder”, “Agent”, etc.
Each “Contact Type” will need to relate to a project reference or ID; I assume this will be via programming at or on form level. So one project can have many Contacts easily referenced and related.
For each “Contact” record I would like the “Contact Type” to be enforced via use of (I’m guessing a sub-form), so for example a Form representing project 007, the sub form will collect data for example the “Owner”, the owner field being pre populated because the owner sub-form is operating or used.
It will be nice if each sub-form as it is used and data collected and saved to the underlying table is turned to grey confirming operation of the sub-form, perhaps some control via VBA and a command button?
Thanks in advance
I would like to develop a form for data entry that will input “Contact Details” into a “Contact Table”. This I find easy to understand if I am only creating one record at a time and the one record is input into an underlying table. However the challenge for me is that my form will need to show many different types of “Contacts”, for example “Owner”. “Architect”, ”Engineer”, ”Builder”, “Agent”, etc.
Each “Contact Type” will need to relate to a project reference or ID; I assume this will be via programming at or on form level. So one project can have many Contacts easily referenced and related.
For each “Contact” record I would like the “Contact Type” to be enforced via use of (I’m guessing a sub-form), so for example a Form representing project 007, the sub form will collect data for example the “Owner”, the owner field being pre populated because the owner sub-form is operating or used.
It will be nice if each sub-form as it is used and data collected and saved to the underlying table is turned to grey confirming operation of the sub-form, perhaps some control via VBA and a command button?
Thanks in advance