Hi all, I have a template that has several user form fields. One "set" of
these fill in fields represents a group of related fields. I want the user
to be able to add/copy the group multiple times if needed. Each of the
fields throughout the template has their own name/bookmark. These fields
will eventually be exported to a comma delimited .txt file and imported into
Access.
I'm trying to write a macro that will not only add or copy the fields and
labels, but also name the bookmarks in a sequential order. This will allow
multiple groups and maintain individuality for the Access database.
I have seen several different ideas such as a table type format and the
corresponding code to copy rows etc. I'm not sure I like the table idea, but
am willing to go that direction if needed.
Here is what the group of fields look like in the template. The fields
follow these lables.
Observation 1:
Discussion:
Recommendation:
Action for Compliance: 0
Recommended Compliance Date:
If I could get an example of how to add/copy a field and label and also
assign a name/bookmark, I could replicate the code accordingly.
Any thoughts or ideas?
Thanks in advance
--
Eric the Rookie