Select A Textbox

[Pestomania]

Hi,

I have a data entry text box in a form called Issue_or_Turnover. I am running a macro that opens an append query based on the text inputted into box Work_Order. At the end of the macro I want the cursor to go back to text box Work_Order.

I have tried many different versions of the setfocus command. Many tries with Docmd.SelectObject but nothing has worked. Ideas?

 

[My Aswer Is This]

Have you tried this:
TextBox1.SetFocus

 

[Pestomania]

Have you tried this:
TextBox1.SetFocus

Yes. Unfortunately, the set focus doesn't seem to go back to the box. It's unbound and I changed the name but SetFocus doesn't seem to work.

It gives an "object required" error. Here's my code:

Issue_To_Floor_Work_Order.SetFocus

 

[JonXL]

Is this part of a With statement? If not, you also need to reference the form, eg, with Me:

 Me.Issue_To_Floor_Work_Order.SetFocus

 

[Pestomania]

Is this part of a With statement? If not, you also need to reference the form, eg, with Me:

 Me.Issue_To_Floor_Work_Order.SetFocus

It is not part of a With statement. And I have tried the ME statements but it states that it's an invalid use of the property.

Hmm. Not easy to type all of the code on my phone, but I'll see if I can Monday.

 

[Micron]

Is there a naming problem here?

I want the cursor to go back to text box Work_Order.

Probably not, as
Issue_To_Floor_Work_Order is the actual name, I suppose. If the control is disabled or locked you can't set focus to it.

Not being much of a macro user, I'll ask - doesn't the macro builder provide the ability to navigate to the proper form/control by displaying these objects in drop-downs (combos) so that you don't get such error messages?

 

[welshgasman]

I think the O/P means VBA when they say Macro, as in Excel macro.
If it was an Access macro they would use the GoToControl action. However it does not supply control names, you have to type them in with no intellisense available.