C
Connie
I have a form with a button that imports data from a link table into a new
table/form using a macro with 30 setvalue actions (that copy data from a
number of fields) on to this new form. This works fine.
However, i would like to set a condition that if the field called 'Type of
Info' is selected as 'archived' then instead of copying the data from the
fields i have defined, it will display an message that says "You are trying
to input an archived record. Please input a current record" - and obviously
will not execute the copying/set command.
While if the record they are trying to copy has the field Type of info as a
'current' record, then it will display another message that will warn the
user that the fields are going to be copied' and will then execute the
setvalue/copying macros.
Bareing in mind that i have no VBA experience and everything is done
currently on macros.
Any help would be appreciated
Thanks
Connie
table/form using a macro with 30 setvalue actions (that copy data from a
number of fields) on to this new form. This works fine.
However, i would like to set a condition that if the field called 'Type of
Info' is selected as 'archived' then instead of copying the data from the
fields i have defined, it will display an message that says "You are trying
to input an archived record. Please input a current record" - and obviously
will not execute the copying/set command.
While if the record they are trying to copy has the field Type of info as a
'current' record, then it will display another message that will warn the
user that the fields are going to be copied' and will then execute the
setvalue/copying macros.
Bareing in mind that i have no VBA experience and everything is done
currently on macros.
Any help would be appreciated
Thanks
Connie