Autokey / SetValue problem

[fieldling]

Hi hope someone can advise me on this:

I've got a form with fields 1 - 12 on it. I've set up an autokey macro so that when I press 'CTRL1', field 1 is updated with a "Y". So far so good...

The next time i press 'CTRL1' I want field 2 to be updated with a "Y" (as long as field 1 is populated). And on the next press field 3 and so on and so on.

I set up another macro with conditions to not update a field unless the previous one is done but this doesn't seem to be working.

Thought this would be simple but it's proving quite a pain!

If anyone has any thoughts or ideas on this I'd love to hear them. It's been a long day.

 

[DarkAngel]

A bit of a botch job (but easy to follow) could be to create a text box on the form that is set to it's value+1 each time the autokey function is pressed. Then you can edit the macro to edit field(value) each time you press the button. Sorry if this isn't any help.

Paul

 

[fieldling]

Thanks, I'll give that a try.