MS Access VBA Object Required Error

Question

Dim maker as String
Set Maker = Forms![A]![B]

I can't seem to get this to work. Every time it runs, it gives me an "object required" error. This is contained within a greater module, but this is the only aspect of it that is giving me a problem.

Basically, I want "maker" to be equivalent to the contents of a text box named B on form A.

Any suggestions?

Fionnuala · Accepted Answer · 2012-12-18 13:53:43Z

8

Do not use Set unless you are assigning an object:

Dim maker as String
Maker = Forms![A]![B]

For an object:

Dim maker as Form
Set Maker = Forms![A]

answered Dec 18, 2012 at 13:53

Fionnuala

91.5k7 gold badges121 silver badges155 bronze badges

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

1 Comment

user1706975 Over a year ago

Worked like a charm. Much appreciated my friend.

Collectives™ on Stack Overflow

MS Access VBA Object Required Error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related