I've got the same problem as Bob below.

S

Sue

I have a form based on a contact (with demographic information) & a subreport
with some information about a series of dates that relate to each contact. I
can't figure out how to add new information to the subreport. I'm having to
go back to the tables to enter new dates. My tables are:
tblClient - mostly demographics
tblSessions - dates of contacts with client, charges, whether billings have
been submitted, and whether payment has been received.

Help?
 
B

BruceM

If you really have a form with a subreport, that won't work. Reports are
for viewing data only. You need a subform. If the subreport looks the way
you want you could copy it in the database window, then paste it as a form.
In terms of relationships, ClientID (the primary key from tblClient) needs
to be joined to a corresponding foreign key field in tblSessions. The
subform control that contains the subform needs to have the Link Parent and
Link Child properties set to these linking fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top