command buttons

[nashr1928]

I have a main form that has command buttons to launch other things. The last one I created doesnt work until I select one of the other buttons and launch something. I close and then the button that wont work does. It only works after choosing another one first. Is there someone out there that has had this happen? Im using access 2003 and xp-pro for an O/S.

[TheShabz]

can you post your code?

[nashr1928]

This is the code for the button in question.

Private Sub Command69_Click()
On Error GoTo Err_Command69_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Tax Information"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command69_Click:
Exit Sub
Err_Command69_Click:
MsgBox Err.Description
Resume Exit_Command69_Click

End Sub

[slave138]

What happens when you click the button before clicking something else? Does it act like it is being clicked (up/down states, showing the focus outline, etc...)? Does it give you an error?

Can you also post the code from one of the other buttons you use which then causes Command69 to work properly?

[nashr1928]

Nothing happens. It is like its not there. I click on a different button and it works. I close where it opened and try the one in question and it works.

[nashr1928]

This is from one that works perfect.

Private Sub Command46_Click()
On Error GoTo Err_Command46_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Billing"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command46_Click:
Exit Sub
Err_Command46_Click:
MsgBox Err.Description
Resume Exit_Command46_Click

End Sub

[slave138]

If you can export the form (no data source needed) I'll take a look at it. I've had similar happen in some of the DBs I have worked on and it's usually something less than obvious...

[nashr1928]

I get this error when trying to attach my file.

[slave138]

Not familiar with that one but you might want to try it again.

[nashr1928]

I compressed the file in a folder.

[slave138]

It looks like the Logon Info button is causing the problems. You can either disable TABbing to it, or move it to the end of the TAB order. If it's not being used, you could also just remove it.

If you simly have to have it as is, you can set a command in the Form's OnLoad event to set focus to one of the other buttons (I used Command35) but any should work since PM Log and Logon Info are the top two in the tab order.

The reason the Taxes button works after clicking on another button is because it passes the Logon Info button in the tab order.

[nashr1928]

Im not familiar with tabs in access. Where do I find it to disable?

[slave138]

Select the button in editing mode and go to the Other section of the Properties. There, you will see a Tab Stop option -- set it to No.

[nashr1928]

I tried setting to no on tabs but still acts the same.

[slave138]

Please upload the updated version