Parameter Value error in my Link Child Master subform

[cimoli]

I have a forms error Enter Parameter Value.
I think the error revolves around a subforms sfrmDetailGroupSummary property Link Child Fields line where i have
[sfrmGroupPeople].Form![ReservationID];[sfrmGroupPeople].Form![ID]

The sfrmDetailGroupSummary Link Master field line is ReservationID;ID

Maybe I need some kind of Parent! thing ??

The mainform is called frmReservation. The first subform is called sfrmGroupPeople that
contains the names or ID's of the people on the reservation.

The 2nd subform (one in question) sfrmDetailGroupSummary tries to link to sfrmGroupPeople
via the ReservationID and the persons ID, and then show the trips they are on.

In sfrmGroupPeople, I have field ReservationID as the Name and Control.
BUT ... i for the ID field, I have the Name as cboNameSearch and the Control as ID.
(Maybe this is my reason for the error???)

In sfrmDetailGroupsummary, the field name ReservationID is used for both the Name and Control
ID name is used for both Name and Control.

Thanks you for any advice.

 

[cimoli]

Never mind. A friend solved the problem.

Thanks anyway. Cimoli

Public Sub LFM_Enter()
On Error Resume Next
DoCmd.OpenForm "sfrmDetailGroupSummary", acNormal, , "ReservationID=" & Me.ReservationID & " And ID=" & Me.ID
DoEvents
Me.cboNameSearch.SetFocus
End Sub

 

[TheAceMan1]

How are ya cimoli ... and Happy New Year if I don't see ya! ...

The relationships between forms are all wrong. If I follow what appears to be the logic flow of the forms, you should have ...

[ol][li]A childField in form [blue]sfrmGroupPeople[/blue], perferably named [blue]ReservationID[/blue]. sfrmGroupPeople should be embedded on frmReservation.[/li]
[li] A childField in form [blue]sfrmDetailGroupSummary[/blue] perferably named [blue]ID[/blue]. sfrmDetailGroupSummary should be embedded on sfrmGroupPeople.[/li][/ol]

With the above the link fields should turn out to be:

sfrmGroupPeople.LinkMasterField [blue]ReservationID[/blue]
sfrmGroupPeople.LinkChildField [blue]ReservationID[/blue]
sfrmDetailGroupSummary.LinkMasterField [blue]ID[/blue]
sfrmDetailGroupSummary.LinkChildField [blue]ID[/blue]

Out of curiosity what are the relationships in your [blue]relationship window?[/blue]

See Ya . . .

Be sure to see FAQ219-2884 Worthy Reading!
Also FAQ181-2886 Worthy Reading!