Trick question

  • Thread starter Thread starter Luis
  • Start date Start date
L

Luis

I have a tricky question that i'd appreciate some help on.
I have a form with a subform. The source data of both must
be a table and not a query because i need to alter some
records. I use a treeview control to select the list of
records on the table. What i'd like is when i choose a
record the subform will display the rest of the data of
that record. Main problem: One record could have one or
more lines of information on the table, and i want that on
the subform, using continuous forms, appears a line of
data for each line of information about that record.
 
I can't help you with the tree control, but you can edit the data even if
you use a query between the form and the table as long as the query is an
updateable query.

For the most part, what you are asking for appears to be a normal main
form/subform setup. If you check the Properties of the subform control with
the main form open in design view you will notice that two of the properties
are Link Parent Field and Link Child Field. Set these to the fields on the
main form and subform that tie the records together and Access will
synchronize the two forms. For this to work properly, the two tables you
mention need to be able to be defined in a one-to-many relationship with a
common field that is a unique identifier in the one side table.
 
Back
Top