I feel really stupid asking this question...

[brian0721]

Ok, I made a form that will track incoming calls and where they come from. There are text boxes for the time, and combo box for the source. However, whenever I close the form and open it back up, all the data that was entered is gone. This seems so simple, but my mind has had it today.

Thanks a ton!

 

[brian0721]

It's not bound to a record source. It is set to data entry, but I still want to be able to see it. The reason it isn't bound to a table is because each name has 2 fields that go with it (date, source) I couldn't think of a good way to make a table that would accomplish this the way I like. Also, there has to be as many entries as possible for each person. Any ideas?

Thanks a ton!

 

[RichO]

Are you saying that there are only 3 fields (Name, Date, Source)?

If this is the case, why not have a table with these 3 fields? As long as you don't set the Name field as a primary key, you can have as many entries for that name as you want.

 

[brian0721]

Are you saying that there are only 3 fields (Name, Date, Source)?

If this is the case, why not have a table with these 3 fields? As long as you don't set the Name field as a primary key, you can have as many entries for that name as you want.

I want a row of headings which each persons name. Then, under each person there will be like 10 rows. In each row, I want there to be 2 things (text box for date, combo box for source) There would these for each person though. There are 5 people, so the column headings would have each persons name (5 total) and then underneath each column would have 10 fields (date/source, * 5 (each person))

Make sense?

 

[RichO]

You can do this with a single table that contains those 3 fields.

Then you can set up a simple 5 column report for the results you need.