I have two forms in question. FrmNewCase is where our admin enters a new case. FrmAllTracker is where several list boxes are referenced, which include New Cases, Case Under Review etc. When she enters a new case on FrmNewCase and hits save, I want FrmAllTracker (which is often already open) to get focused and automatically select the new case from the NewCase list box. I have the setfocus VBA down, but I can't seem to get the VBA to select the listbox. I get the "Object Required" error. Here's what I have (this was just a test button, it's not the button I'll really be using)
Private Sub Command25_Click()
Forms!FrmAllTracker.SetFocus
Forms!FrmAllTracker.Requery
Forms!FrmAllTracker.NewCaseList.Selected(NewCaseList.ListCount - 1) = True
End Sub
Any help or suggestions, maybe OpenArgs? But I'm wayy to unfamiliar with that to use it correctly (tried DoCommand..... , , , , , , , NewCaselist... and poop)
THANK YOU!!!
Private Sub Command25_Click()
Forms!FrmAllTracker.SetFocus
Forms!FrmAllTracker.Requery
Forms!FrmAllTracker.NewCaseList.Selected(NewCaseList.ListCount - 1) = True
End Sub
Any help or suggestions, maybe OpenArgs? But I'm wayy to unfamiliar with that to use it correctly (tried DoCommand..... , , , , , , , NewCaselist... and poop)
THANK YOU!!!