Re: Subform: record select form other subform

Tech-Archive recommends: Fix windows errors by optimizing your registry

Chris wrote:

Does the following change your previous response?

Main form: clients

Subform level 1:
Reservations; form is container for tabs with subforms of InvNum and
ClientID related information. Master/Client=ClientID/ClientID

Subform level2:

Contiuous: Selected client's invoices summary. Master/Child:ClientID/ClientID

Single form:
Selected (at continuous form) client invoice details. Master/Child:
ClientID/InvNum.

I was advised a while back here at this NG to build this container so that I
could limit the invoices to the selected client. I also have the related
tabs/subforms which we have not discussed that are either InvNum or ClientID
dependent. This structure allows those all to work fine -- except for this
navigation button to select the desired record on the continous form.

If there is a better way that does the same and warrants changing, I'm
prepared to try it. I need to show the invoice summary of the client upon
viewing client and allow for the user to go to a details tab/subform.


This additional information about the main form and subform
is about what I suspected. It does confirm that I hadn't
gone down the wrong track, but it does not change what I
think the problem probably is. The single form's Link
Master/Child should be the same as for the single form:
ClientID/ClientID
Otherwise the single form can not contain the same set of
records as the continuous form.

With the Link Child property set to InvNum, the only records
that will show up in the single form are the unlikely ones
where the InvNum just happens, by coincidence, to be the
same as the ClientID, probably the first client and first
invoice entered into the tables. You can check my
hypothesis by looking in the table at the one record the
code does find to see if the two fields are the same.

I really think that RIGHT JOIN should be an INNER JOIN even
if you do have RI set on the relationship.

--
Marsh
MVP [MS Access]
.

Quantcast