how to view all records in a single access subdatasheet

G

Guest

I have a contact database and place several calls to clients. I was able to
view all of the call log records for each client in a subdatasheet while
working in the contact table. Somehow, it changed and I can only view one
call listing in the subdatasheet at a time. How can I change the
subdatasheet back so I can view all of the call records for each client while
working the contact table?
 
J

John Vinson

I have a contact database and place several calls to clients. I was able to
view all of the call log records for each client in a subdatasheet while
working in the contact table. Somehow, it changed and I can only view one
call listing in the subdatasheet at a time. How can I change the
subdatasheet back so I can view all of the call records for each client while
working the contact table?
Click to expand...

Well... I'd strongly suggest NOT using table datasheets for any
purpose other than debugging and design.

Create a Form based on your Contact table, with a continuous Subform
based on Calls. This will display (and let you edit) all the calls for
each contact.

John W. Vinson[MVP]
 

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

Similar Threads

Printing records in a subdatasheet 3
Combobox in Subdatasheet 12
subdatasheet switches to [auto] 1
Printing Subdatasheet in a Table 2
Accidentally removed subdatasheet 3
Set subdatasheet name to none when upsizing to SQL? 9
specifying which subdatasheet in Access 2003 3
can't add a subdatasheet to a linked table 1

Top