Text box, adding but no editing

[tjcinnamon]

I have a text box that I only want people to add new data to. I would like them to be able to view previously entered data but not able to edit it. I've tried to lock the data but then I can't add new data.

Any suggestions appreciated,
Joe

 

[ansentry]

Joe,

Under form Properties /Data, change Data Entry to "Yes". With this set to "Yes", the form opens to a blank record.

After the user enters the data they can only close the form or go to a new record.

To view the "previous data" add an unbound list box to your form. Make its source is a query based on the table that is the source for the active form. Sort the query using the /an autonumber field descending.

In the oncurrent event of your form requery the list box, so that when the user entered data, goes to a new record the requery runs and the previous data will appear at the top of the list.

Hope this helps, if it is all as clear a mud, post back and I will send you a sample db.