subform not saving all records

P

Pamelia

I am using Access 2003. I have a subform that gets it's information from a
form that shows services and dates that the client on the main form has used,
but the subform will only save the first service and then every time a new
service is entered the the second record changes. What I am trying to do is
have a running account of the services each client uses in our agency on the
main form that has all the other pertinant info. Any help would be
appreciated. Thank-you
 
S

SusanV

What's your table structure? You should have one table for your client
information, then another table with service info - set a one-to-many
relationship, the many side being the service table, using the client ID.
The subform data would come from the service table.
 
Top