Is it possible to create a form that resembles a table?

F

forest8

Hi there

In my database, I need to create a contact log?

What I need to do is have any contact log entries look like a table?

In my table, I have the following fields:

StudentID_FK, DateComplete, CommunicationMethod, CaseNotesCompleted (Checkbox)

The user wants to see all the contact log information when they add new
information to the table.

I want to see all previous information for each student as I enter new data.

How should I set this up?

Thank you
 
J

Jeanette Cunningham

Have you tried using a continuous form for the contact log?
You can put the continuous form on a subform control on a main form that is
based on the student table.
Put a combo box in the header of the main form so users can choose a student
and then the contact detail for that student will appear in the subform.
In the bottom row of the subform, users can add a new row to the contact
log.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 

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

Mail Merge file containing a Word Table 0
Is this possible? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Create a chart from a table in word thats dynamic 0
Crating User Form to Add Names 1
Doughnut Chart linked with the slicer in the pivot table 0
Setting column width in a table with a macro is not working 0
Add additional information to excel form after original data entry 0

Top