Embedded Subforms

[Kirk P.]

I've got a parent form (frmParent) with a subform (sfrm1) on which another
subform (sfrm2) is embedded. The subforms are displayed in datasheet view,
so the little + sign displays in order to expand the recordset. What I would
like is when clicking on the + sign in order to get at the records in the
lowest subform (sfrm2), the cursor jumps to a new record, and only displays
records with a Transaction Date within 60 days of the maximum transaction
date stored.

Is this possible?

 

[Albert D.Kallal]

Hum, datasheets, and sub-datasheets don't offer a lot of control...

I think if you need better control, then I would consider building a NICE
interface based on a form + 2 sub forms.

Take a look at the last screen shot in the following:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

Notice how on the left side, you can enter customers, and on he right side,
you can disperse payments for a given cheque amount..

The above type of interface means you can setup the data for the form on he
right side to your criteria. The above is just a idea, or suggestion, but as
a general rule, I find that you have little control when you use a datasheet
view...and continues forms offer better control (but, are often more work to
setup).