Best way to display subset of table information for particular use

  • Thread starter Thread starter Peter S.
  • Start date Start date
P

Peter S.

I have a form that displays information on a particular individual. That
individual could have information that details dates and money received on
those dates. I am looking on the cleanest approach to displaying this
information (in a subform) for that particular user while letting them view,
delete and add information. There could be 20 entries (dates and monies) or
there could be none. How can this be best accomplished allowing the user to
view any and all entries and delete/modify entries or even add a new one? Any
suggestions?
 
If the entries are in a separate table (they should be) then a subform should
be exactly what you need.

Your main form should only display the information about the individual while
the subform would contain the information on the transactions. You would use
the subform control's Link Child Fields and Link Master Fields property to set
up the linkage between the form and the subform. If you do this Access should
automatically handle filling in the foreign key fields for the transaction.

Your main form will display the data using Single Form view. It cannot be a
continuous form. I would probably use continuous form view for the data in the
sub form unless you have more information then you stated for the transactions.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Ahh, that sound doable. I set it continuous form and it looked good. The only
thing is that I want the fields/records to be spaced together like a
spreadsheet. Seems like they are too spread out. is that doable?
 
Sure open up the subform in design view and move the controls around until you
get the desired effect. Then save the changes.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Works great, thanks!!

John Spencer said:
Sure open up the subform in design view and move the controls around until you
get the desired effect. Then save the changes.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
Click to expand...
 
Back
Top