Entering user name automatically when log in to a form

[V760838]

Hi,



I am working on a database with customer's orders. I have created a log in form for customers. After log-in, the customers can place their orders. However, I want that after log in to the customer's ID ( with which he is logging -in) should be automatically populated in the customer ID field of the order form so that no one mischievously places order for some other customer. Also the customer ID field should be locked for editing. Please help me, Thanks

[pbaldy]

Save the login info via whatever means (leaving the form open but hidden would be one simple way). Have your entry form textbox use that value as the default value, and lock the control so the user can't change it.

[V760838]

Thanks for your suggestion. I am a rookie to access. I don'n know how do I make my entry form as default value of the log in ID. Someone suggested me to use VB code to copy the LOG-IN ID to the order form Customer ID, when LOG-IN command button is pressed ( and the log-in is successful). However, I don't know the coding. If anyone knows, please suggest.

[pbaldy]

You just put a reference to the form in the default value property of the textbox. Use the Build function to get the syntax right. That would mean you would just hide the login form rather than closing it.