I have a form that is broken down into 24 sub forms.
these are all tied to one subform, they are filtered based on other
things.
But I need to change the sub forms source object based on a selection.
I was going to try this..
For Each doc In dbs.Containers("Forms").Documents
frmname = doc.Name
If frmname = "DM hx1Mon" Then
DoCmd.OpenForm frmname, acDesign, , , , acHidden
For Each ctl In Forms(frmname).Controls
If ctl.ControlType = acSubform Then
For Each prp In ctl.Properties
Debug.Print "Just looking "&
prp.Name
Next
end if
next
End If
I can't find out exactly what I need to change.
just need to change "subfrm_drub_visit_1mon"
to "subfrm_drub_visit_3mon"
something like this
any pointers would be greatly appreciated