Need help with syntax please

[Gina Maylone]

Database tracks group home residents medical information. Lots of fields and subforms. So I thought it would be cool to create a Quick Access form, where a user could choose the resident and the area they want to enter data for. I created a table that contains the name of the parent form, the child form, the short name and the abbreviation of the form that I use on the parent form to identify the subforms.



For example:

ParentForm	Subform	Shortname	Abbr
ResidentInformation	ResidentDME/SuppliesSubform	DME/Supplies	RDME

And my code successfully opens the correct form:

Private Sub FormList_AfterUpdate()
Dim reqform As String
Dim abbr As String

reqform = Me.FormList.Column(1)
abbr = Me.FormList.Column(3)

DoCmd.OpenForm Me.FormList.Column(1), , , "residentid=" & Me.ResidentList.Column(0)

Forms!quickaccess.FormList.Column(3).SetFocus

End Sub

Once the form is opened I want the focus to be set to the appropriate subform (the abbr), my latest attempt is the last line in my code above. I know it's totally wrong and I get the "object required" error. I don't want to put the set focus code in the "on open" event because the forms could be opened from several different places. Any thoughts? Is this even possible?

TIA!

[June7]

Never seen anything like this. Don't think I would do this.

Is reqform supposed to hold name of parent form?

Is abbr supposed to hold name of the subform container control?

If yes to both:

Forms(reqform).Controls(abbr).SetFocus

[Gina Maylone]

Thank you June. Getting closer...still tweeking. Why wouldn't you do this?

[Gina Maylone]

This worked:

Forms(reqform).Controls(abbr).Visible = True

[June7]

Maybe I'm just lazy. Seems like an extra development step and I'm just not seeing any advantage gained with creating this table. Why not just reference names directly in the code?

[Gina Maylone]

Maybe I'm just lazy. Seems like an extra development step and I'm just not seeing any advantage gained with creating this table. Why not just reference names directly in the code?

Hmmm...I don't know. Guess it's just the way my brain works. Or doesn't work. ;-)

Thanks for your help!