Locking a table

[jonu61]

Hi.
I am creating a database to keep an inventory of doucments. I have a text box on a form that when I type in a document id it and click on the retrieve data button it will open the document details in a report. I have the textbox control source set to the DOC ID field in the table. Whenever I type in a document name to open it up it will open up the document in the report like I want it to. The problem is I opened up the table to look at it after this and it changes the DOC ID in the table's first field to whatever I type in the textbox. For example I am wanting to look at DOC-1010-0005. I type this into the textbox and click on the retrieve button. Everything works properly. I open up my table and DOC-1010-0001 is changed to DOC-1010-0005. What can I do to keep this from happening? Thank you very much for any help in advance.

Thanks,
Jon

 

[KenReay]

Hi

You have your text box bound to the underlying data, so when you type in the text box it updates the table, make the text box unbound, this will probably mean you need an additional text box control to show the document id retrieved, (which is bound), if so set the locked property of the (new) text box to true, this will prevent you accidentally overtyping data in the table. You may want to set the locked property of otehr controls being used to display the data retrieved for the same reason.



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK