A form for a query relating 2 tables

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

Hi,

I am new in Access and I have been tried for a long time
to do the following:

I have 2 tables: * Details: contains name, ID, telephone
and etc.
* Data: name ID, the date this person
called, for example and etc. Of course each person can
call severl times so he will have several lines in the
data table.

I made a query that relates those 2 tables by the
person's ID.

I am trying to create a form that by choosing a person's
name, all of his details from the details table are
updated in the relevant fields of the form.

I will appriciate any help with it
Thanks
 
sounds like you need to create a form with a sub form.
enter the name of the person in the name field. in the
query design grid, in the name field criteria enter forms!
form name!field. asign the query to a button to trigger
the query to run and populate the subform.
email me at (e-mail address removed) and i'll send you the code.
 
Back
Top