Afternoon all. Am having some trouble I hope you can help with.
I have twelve fields in a table (Labelled 1 - 12). I have created an autokey/setvalue macro so that when I press CTRL1, field 1 is populated with a "Y". So far so good.
What I need to be able to do is press CTRL1 again and field 2 is populated with a "Y" (as long as field 1 has already been done) and on the next press field 3 etc.etc.
Thought it would be easy but it's giving me a real headache. Anyone got any ideas? Thanks.
I have twelve fields in a table (Labelled 1 - 12). I have created an autokey/setvalue macro so that when I press CTRL1, field 1 is populated with a "Y". So far so good.
What I need to be able to do is press CTRL1 again and field 2 is populated with a "Y" (as long as field 1 has already been done) and on the next press field 3 etc.etc.
Thought it would be easy but it's giving me a real headache. Anyone got any ideas? Thanks.
Comment