on Pop up Form

[waqas]

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.

[Robeen]

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:

 
        With frm
            .AllowAdditions = True
            .AllowDeletions = True
            .AllowEdits = True
        End With

This page has some useful information:
http://office.microsoft.com/en-us/ac...001232718.aspx

I hope this helps.

[waqas]

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

[Robeen]

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:

 
Me.AllowEdits = True

3. When I ran the Form - I could not Edit any of the data.
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.

[waqas]

THANKS i will check in my office and let you know