How to create dynamic VBA for Access code which will build

Question

I have been successfully using code such as:

Forms![MyForm]!Option1 = False

However, I now wish to make the above dynamic by using N = 1,2,3,4 etc. So the new code would look something like:

Forms![MyForm]!Option & N = True

Does anyone have any hints about how to make this work?

Many thanks.

HackSlash · Accepted Answer · 2020-04-07 15:04:34Z

1

You want to avoid using bang notation !. Instead, use fully qualified references like this:

Forms.Item("MyForm").Controls.Item("Option" & N).Value = True

If you want to know more about bang notation there are SO threads like this one about it: Bang Notation and Dot Notation in VBA and MS-Access

answered Apr 7, 2020 at 15:04

HackSlash

6,0272 gold badges28 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1