Form/Design question

[Rpettis31]

I have a form that I intend to have a text box that is used to record data
from the user, upon selecting a command button the data in the text box will
appear in a list box with the date.

Such as -- 9/4/08 -The issue was opened.
This is bound to a field on a table called Status. However, once the record
is entered the value appears for all records. If I close the form and return
to the record the data is not there.

Question is this the best way to do a status notes? Also this field will
need to be updated so How do I prevent the initial data from being
overwritten?

 

[KARL DEWEY]

Sounds like it is not bound to the status field. What type of field is status?
You will need to edit the data to add more information.
Or use a listbox, query, and another table with one-to-many relationship.
The query needs to sort to display last status as first record.
Another method is to use an event that concatenate the new data to the old
data on update/change.

 

[Rpettis31]

I have a list box in the form that is fed via the text box that adds the
intformation to it. The listbox is a memo field in the table. I am trying
to make a log of activity notes that is entered by the user rather than a
memo box.

I am able to enter data in the text box and click the command button and it
appears in the list box.

1. The data is not found in the table in the bound field.
2. Every other record on the form shows the data entered on that one record.
3. When exiting and returning to the database the information is not on the
record where it was entered.

I am frustrated at what I think should be a very simple thing.

 

[KARL DEWEY]

I have a list box in the form that is fed via the text box that adds the
intformation to it.
How does the information get from the text box to the list box?
Is the information for each status entry so large that you need a memo filed
to contain it? More than 255 characters?

Can you enter data directly into the list box and it be added to the record?