Read Only Form (Problem)

dsetiadi

College Student
Local time
Today, 04:31
Joined
Aug 12, 2005
Messages
7
I created a button that opens a form with a specific data in a 'read-only form'. The first one is using macro, and the other one is using visual basic. The problem is that that button opens the right form with the right data (based on the linkcriteria), but the format of the opened form is still editable. Can anybody help with my problem, please?

Dedi
 
Dedi,

Your Command Button code should look something like this:

DoCmd.OpenForm "YourForm", , , "[Key] = " & Me.SomeKey, acFormReadOnly

Wayne
 
I still got the same problem. My opened from is still editable. Do you think the problem is related with the form, not with the visual basic?

Below is the lines of codes that I used to open the form:
Private Sub Troubleshoot2_Click()
DoCmd.OpenForm "Projects", , , "[Projects_ProjectID] = " & Me.ProjectID, acFormReadOnly
End Sub

Dedi
 

Users who are viewing this thread

Back
Top Bottom