Two forms one table

  • Thread starter Thread starter zonk2439
  • Start date Start date
Z

zonk2439

Is it possible to have a sub-from on my main form which lists the contents of
say "table 2" in a datasheet, this way I can see all entries, and then with
in that sub-form double click on one of the entries and have it open up in a
new full form for editing and what not.

Thanks for any help...I am lost!
 
Just use a continuous form or datasheet as a main form to display all of
your records. Then use the double-click event of a control or the record
selector (the form's event) to open another form to that record:

DoCmd.OpenForm "FormName",,,,"IDField =" & Me.txtID

where txtID is the name of the textbox that holds your primary key field.
 
Back
Top