linked form instead of sub form

[weezles]

hi

I'm having trouble with using a linked form instead of a sub form on a 1 to many relationship. Then linked form can be accessed from various other forms. When it opens the linked form, if there are no records the clientID is 0.
I tried the code behind the button to open the linked form.

stLinkCriteria = "[ClientID]=" & Me![ClientID]
DoCmd.OpenForm "frmLinked", , , stLinkCriteria

If Forms!frmMain!ClientID = 0 Then
        Forms!frmLinked!ClientID = Forms!frmMain!ClientID
End If

I would set the default value of ClientID to:
Forms!frmMain!ClientID
but as the parent form could be any of many I need to find another way.


Help

Lou

 

[PHV]

Have you tried to replace this:
If Forms!frmMain!ClientID = 0 Then
with this ?
If Forms!frmLinked!ClientID = 0 Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[weezles]

Yes sorry my mistake when changing the form names to supposedly make it easier to read.

stLinkCriteria = "[ClientID]=" & Me![ClientID]
DoCmd.OpenForm "frmLinked", , , stLinkCriteria

If Forms!frmLinked!ClientID = 0 Then
        Forms!frmLinked!ClientID = Forms!frmMain!ClientID
End If