Transferring data from tables to forms

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have two tables, Clients and Activity. The Client
tables contains all personal data and the Activity table
contain case notes, etc. for each session with the client
(there are many sessions with each client). I have a one
to many relationship set up between the Client table and
the Activity table. The primary key on both tables is the
clients social security number. On the Activity Form, I
want to pull Name, Address, etc. from the Client tables
when a SSN is entered. That information, along with the
session case notes, dates, etc. I would like retained in
the Activity table when the case note is saved.

I have tried Dlookup but continue to be getting error
messages. Any help would be appreciated.

Thanks,

John
 
John,

Create a new form based on the Activity table or a
query using the Activity table as its source. Open your
old main form in design view. Using the subform/subreport
wizard method at the top of the screen, place a subform in
the main form. When answering the subform/subreport
wizard questions, mention the new form you made as the one
you want to be the subform, and mention the common field
between the main form and the new form to be the social
security no.

You can then adjust how you want the subform to
appear using the sizing of its boundaries.

Save the main form with the new subform contained.

Open the new main form, and the subform will present
the client information per social security no. of the
Activity main form record.

Casey
 
Back
Top