How to open form on specific field

[krigsby]

I have a lookup macro to open a form when the selected field is clicked. I was able to use OpenForm Macro and use the where condition to open the correct record. However, the 2nd macro I put in place is not working. I used GoToControl and selected the field I wanted to be on when the form opened. What am I doing wrong? Do I need to continue the OpenForm where condition to include which field to land on when it opens the new form? The form I am trying to open is Main Form. The field I am trying to place the cursor on when the form opens is Abuser Name.

[matt_wpg]

Having the exact same problem! I hope we get an answer here...

[pbaldy]

Typically you wouldn't use code, you'd make the desired control first in the tab order.

[krigsby]

The field is different depending on what they choose in another field.

[pbaldy]

Then I would expect GoToControl to work, though I don't use macros. Can you attach the db here?

[krigsby]

I have tried the GoToControl and it doesn't work.

[krigsby]

I don't know how to attach.

[pbaldy]

Do a compact/repair, the zip the file. Then you should be able to attach it in the "Go Advanced" area.

[krigsby]

I have attached it as a zip. I am new to this so you will probably find it is very basic.

[krigsby]

I also have this question since you can see my database. Hopefully you can help with it as well:
I have set my form up to have several pages. However, when I move from page to page, it doesn't always begin at the top. I have tried maximize page on click and it doesn't seem to work for pages. What do I enter to have it go to the first tab on the page as you select the page and where do I attach it?

[krigsby]

I attached it. When you go to lookup a client, you can click on the client name and it will take you to the specific record on the main form. However, I also need it to go to the actual field where the client name is located.

[pbaldy]

Not sure what you're having trouble with. I added GoToControl after your OpenForm and put [Client Name] as the control name, and it appears to work.

[davegri]

Option Compare Database
Option Explicit


Private Sub Client_Change()
Select Case Client.Value
Case 0, 1, 3, 4
[Client Name].SetFocus
Case 2
txtDummy.SetFocus
End Select
End Sub


Private Sub Command726_Click()
DoCmd.GoToRecord , , acNewRec
End Sub

Code is for Main Form
Remove all the on_click embedded macros for ALL the tabs at the top.
on tab Client Data, add a textbox named txtDummy at the top: height .001, Width .001, Top 0, Left 0, background transparent. You may have to remove layout for the entire tab contents to do that.
Command726 was existing code.

[krigsby]

I wasn't using the brackets. That is all I needed. THANK YOU!

[krigsby]

What about this question? Can you help with this as well?
I have set my form up to have several pages. However, when I move from page to page, it doesn't always begin at the top. I have tried maximize page on click and it doesn't seem to work for pages. What do I enter to have it go to the first tab on the page as you select the page and where do I attach it?