hi experts.
kindly guide me which properties have to set no that when form open user can not edit data but when press button user can edit and save.
hi experts.
kindly guide me which properties have to set no that when form open user can not edit data but when press button user can edit and save.
Hi Waqas,
In design mode
Go to the Property Sheet for the Form,
Click on the Data Tab.
Set the Allow Edits and other 'Allow . . .' Properties to No.
When the Form is open and your button is cllicked - you could have code behind the button to change the Allow properties to Yes.
Something like this:
This page has some useful information:Code:With frm .AllowAdditions = True .AllowDeletions = True .AllowEdits = True End With
http://office.microsoft.com/en-us/ac...001232718.aspx
I hope this helps.
thanks
i did same but when i run form it comes blank no data and field are appearing when i press button to set these properties yes the
only fields appear blank without data![]()
I just tried this for myself - just to make sure it worked.
1. On a Form - I went to Property Sheet | Data and turned Allow Edits to False.
2. In the code for a command button on the Form I typed in:
3. When I ran the Form - I could not Edit any of the data.Code:Me.AllowEdits = True
4. When I clicked the Command button - I was able to Edit data on the Form.
Let us know if you're still having trouble.
THANKS i will check in my office and let you know