Hi,
I created a macro on a subform that does setProperty value to Bob in the helper field.
Works for first record in subform.
I only have 3 helpers Bob, Susan and Sam so I created 3 macros for each value.
So I created 3 macros they work fine. The problem is how do I make them move to new record.
some times Bob and Susan help and or all three help so I need 3 records added.
example if I run the Bob macro my macro adds the first record with Bob name. Then if I run the Sam macro it changes Bob to Sam in same record. Then if I run the Susan macro it changes Sam to Susan.
I want it to add a record for Bob when I run the Bob macro and add a record for Sam when I run the Sam macro. So I can see that Bob and Sam were helpers.
Thank you.
I created a macro on a subform that does setProperty value to Bob in the helper field.
Works for first record in subform.
I only have 3 helpers Bob, Susan and Sam so I created 3 macros for each value.
So I created 3 macros they work fine. The problem is how do I make them move to new record.
some times Bob and Susan help and or all three help so I need 3 records added.
example if I run the Bob macro my macro adds the first record with Bob name. Then if I run the Sam macro it changes Bob to Sam in same record. Then if I run the Susan macro it changes Sam to Susan.
I want it to add a record for Bob when I run the Bob macro and add a record for Sam when I run the Sam macro. So I can see that Bob and Sam were helpers.
Thank you.