Close one form open another and set focus to a specific field

[Derrick T. Davidson]

Hi I am learning code with the help of you experts so apologies if this is very basic to you, here is my latest issue

I close [form1], I open [form2] and want go to [fieldwidgets]



I coded the following:
*************************
DoCmd.Close,""
DoCmd.OpenForm"Form2",acNormal,"","",,acNormal
DoCmnd.GoToRecordacForm,"form2", acLast
Me.SetFocus "fieldwidgets"

*************************
I get the error
Run-timeerror ‘424’:
I know I am doing the set focus wrong, but not sure what is wrong??
Objectrequired

[burrina]

Where is the code at? Which form? Are the two forms linked?
Also, you can't close the active form and then open another form. The DoCmd.OpenForm code goes before the close command.

[Derrick T. Davidson]

This code:
***************
DoCmd.Close , "" DoCmd.OpenForm"form1", acNormal, "", "", ,acNormal
DoCmd.GoToRecord acForm,"form2", acLast
Me.SetFocus ”FieldWidgets”
******************
works fine without the set focus line, it closes the active form opens the new one and goes to the last record?

[Derrick T. Davidson]

This code:
***************
DoCmd.Close , ""
DoCmd.OpenForm"form1", acNormal, "", "", ,acNormal
DoCmd.GoToRecord acForm,"form2", acLast
Me.SetFocus ”FieldWidgets”
******************
works fine without the set focus line, it closes the active form opens the new one and goes to the last record?

[Derrick T. Davidson]

This code:
***************
DoCmd.Close , ""
DoCmd.OpenForm"form2", acNormal, "", "", ,acNormal
DoCmd.GoToRecord acForm,"form2", acLast
Me.SetFocus ”FieldWidgets”
******************
works fine without the set focus line, it closes the active form opens the new one and goes to the last record?

[burrina]

Try this. Is that your only issue?

Me.FieldWidgets.SetFocus

[Derrick T. Davidson]

I get this

Error Message
**************
Compile Error;
Method or data member not found
********

[burrina]

Then you need to refer to the name of the control, not the control source. Assuming you have typed it in correctly in the first place.

[Derrick T. Davidson]

Please letme explain what I am doing:
1. The first input is a transaction this is a bulknumber used in financial records later i.e. 200
2. After that a pop up (popup1) form breaks downthe transaction in to components
a. i.e.
b. Ink 50
c. Paper 50
d. Cartridge 100
3. If this is a new supplier then the forms forcesthe user to enter the category of the supplier and closes popup1. Another pop up (popup2) shows to enterthe category
i.e.
a. Print Supplier
b. Canvas supplier etc.
4. After the category is entered the popup2closes and popup1 re-opens to continue entering the break down information,with the current settings popup1 goes to the initial (firstfield). What I am trying to do is go to the next entry point in popup2which is halfway down the form.

[burrina]

Try this. Unsure what is going on?

Forms!YourFormNameHere.SetFocus
Me.yourfieldname.SetFocus

[Derrick T. Davidson]

Same error message, guess I will leave it alone.................

[burrina]

Up to you. I still say check your field names and refer to the name and not the control.

Good Luck!

Going to bed now.

[Derrick T. Davidson]

Just in case anyone else is looking for an answer the solution is shown below

Please letme explain what I am doing:
1. The first input is a transaction this is a bulk number used in financial records later i.e. 200
2. After that a pop up (popup1) form breaks down the transaction in to components
i.e.
a. Ink 50
b. Paper 50
c. Cartridge 100
3. If this is a new supplier then the form popup1forces the user to enter the category of the supplier and closes the popup1window. Another pop up (popup2)opens to enter the category
i.e.
a. Print Supplier
b. Canvas supplier
c. Trucking, etc.
4. After the category is entered a buttonis clicked the popup2 closes and popup1 re-opens to continue entering the break down information, with the current settings I had popup1went to the initial (first field). What I wanted to do is go to the next entry point in popup2 which is halfway down the form.
5. After searching for the answer the code below is what I added to the button on click,and it works like a dream.

*************************************************
DoCmd.Close, ""
DoCmd.OpenForm"popup1", acNormal, "", "", , acNormal
DoCmd.GoToRecordacForm, "popup1", acLast
Forms!popup1.SetFocus
Forms!popup1.FieldWidgets.SetFocus
***********************************************