DataSheet View won't STICK

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Hi folks! Using A02 on XP. Have 5 fields in a query and
only want to allow 1 field to be edited. So, I made a form
and made the default view 'datasheet' and locked all the
fields except the one to be edited. However, someone else
opens the form on their PC and it is in single record view
not datasheet view. How can I make that property STICK?
Here is what is in my OnClick to open the form. Should a
change go here?

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "fCSRPlansAssigned"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Thanks in advance for any help or advice!!!
 
Hi folks! Using A02 on XP. Have 5 fields in a query and
only want to allow 1 field to be edited. So, I made a form
and made the default view 'datasheet' and locked all the
fields except the one to be edited. However, someone else
opens the form on their PC and it is in single record view
not datasheet view. How can I make that property STICK?
Here is what is in my OnClick to open the form. Should a
change go here?

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "fCSRPlansAssigned"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Thanks in advance for any help or advice!!!
Click to expand...

Regardless of the Default View property setting of a form, if you open
the form using the OpenForm method you MUST explicitly open it in
datasheet view:
DoCmd.OpenForm stDocName, acFormDS, etc....
 
Fred, you are the GREATEST!!! I thought it might be
something that belonged between the commas. You are one of
the reasons that I am able to learn so much here. I LUV U
GUYS!!!
 
Back
Top