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!

 

[Pat Hartman]

It's hard to tell from your description what the problem might be.
1. If the form is not bound to a RecordSource, no data will be saved unless you write a great deal of VBA to take care of saving.
2. If the form's data entry property is set to Yes, it will not show existing rows. It will open empty and only show those rows that were added between the time the form was opened and when it was closed.

 

[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.