Object doesn't support this property or method....

[Guest]

There was a previous post back in May to the same error I am having but I
didn't see a solution to it.

I am receiving this same error and my field is not locked either. Why is
this happening? When I use this line of code "me.[submitted by:]." in the
drop down all I see is "value" ....."setfocus" is not an option so what do I
need to do in order to have that as an option?

thank you,
MN

 

[Allen Browne]

Sounds like you have a *field* named [submitted by:] in the table that feeds
your form, but there is no *control* by that name on the form.

You can't SetFocus to it unless it is the name of a text box or other
control on the form.

It is possible to have a text box with the Control Source named [submitted
by:], but its Name property is Text153 or something else.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

There was a previous post back in May to the same error I am having but I
didn't see a solution to it.

I am receiving this same error and my field is not locked either. Why is
this happening? When I use this line of code "me.[submitted by:]." in the
drop down all I see is "value" ....."setfocus" is not an option so what do
I
need to do in order to have that as an option?

thank you,
MN

Is that textbox locked? Are you sure the name is correct. When you type
it
in MSA should automatically dropdown with the options that are available
assuming that you are using Me.Broker.SetFocus.