sub form to another sub form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

have a remittance main form that has a sub form that allows the posting of a remittance date, payments, allowances
the visit date and the charges come from another module
would like to go to a detail sub form, to show the components that built a specific visit date
the linkage of the main form to the sub form is by account number

when i try to do a command button on the sub to call the detail form, i get all accounts instead of the specific account

what is a good way to link

also, is there a way in access that you can do a + - deal when you want to collapse the detail or expand?
 
-----Original Message-----
have a remittance main form that has a sub form that
Click to expand...
allows the posting of a remittance date, payments,
allowances.
the visit date and the charges come from another module.
would like to go to a detail sub form, to show the
Click to expand...
components that built a specific visit date.
the linkage of the main form to the sub form is by account number.

when i try to do a command button on the sub to call the
Click to expand...
detail form, i get all accounts instead of the specific
account.
what is a good way to link?

also, is there a way in access that you can do a + - deal
Click to expand...
when you want to collapse the detail or expand?
.
Click to expand...
Hi jn,
if the command button is opening another form to a
specific record then you will need to know the unique
idenfier for this record. You mentioned that the link from
the main form to the subform is the account number. What
is the link from the subform to the detail form?

Assuming that the button to open the detail form is
located on the subform and that the linking field is named
detailID, then use the following as an example...

docmd.openform FormName:="frmDetail",
WhereCondition:="[detailID]=" & me.detailID

replace names with you object names.

Luck
Jonathan
 
Back
Top