Macro to enter data into subform

[tinher]

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.

 

[theDBguy]

Hi. Can you show us your macro code?

 

[tinher]

I created a button and the on click is set to

SetProperty
ControlName Helper
Property Value
Value Bob

I need to add something that changes focus to next record but everything I have tried gives me an error.

This is in a subform so when I use goto new record or next record it says the form is not open

I tried the after update on the helper field also.


Thank you.

 

[theDBguy]

I created a button and the on click is set to

SetProperty
ControlName Helper
Property Value
Value Bob

I need to add something that changes focus to next record but everything I have tried gives me an error.

This is in a subform so when I use goto new record or next record it says the form is not open

I tried the after update on the helper field also.


Thank you.

Hi. I just gave it a try and didn't get any error when I told the macro to go to a new record. Here's what my macro looked like: