Half and Half

[misuser2k7]

I am creating a data entry form which will have some fields which will be pre-populated (on load) with data from a table (these fields cannot be edited) and data in other fields will be entered by the users to be stored in the same table.

Is there a way to make half the form in 'snapshot' recordset type and the other half in 'dynaset' recordset type to achieve this "half-and-half" arrangement OR is there a way to do achieve this through an alternate method?

Thanks.

 

[MajP]

you can lock controls for edititing.

 

[misuser2k7]

MajP,

I have locked the fields that are supposed to be non-editable but they only display data when the form is set to the 'snapshot' recordset type. When I change to 'dynaset' recordset type, all controls are blank with the non-editable ones not allowing any data entry like they are supposed to. When the form is in the 'snapshot' recordset type mode, the other (editable) controls also behave like locked ones.

I also tried putting the non-editable controls in the form header to distinguish them but all the controls still behave like each other depending on the recordset type.

Thanks.

 

[misuser2k7]

Found the solution!

https://support.office.com/en-ie/article/RecordsetType-Property-dbe9dd7a-cc73-4539-aaa7-9e6b55034052

Change the conSnapshot value to 4 as follows:

Sub Form_Open(Cancel As Integer)
Const conSnapshot = 4
If gstrUserID <> "ADMIN" Then
Forms!FormName.RecordsetType = conSnapshot
End If
End Sub

Thanks.

 

[SkipVought]

Rather...

Assign the RecordsetType to 4!

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}