keep from changing current record

[illuzioner]

Hi,

Is there any way to disable record selection in the details section of a continuous form without turning its visibility off?

I want to prevent the user from changing the current record, but I still want to show the all the records (in the details section) and make the current record editable (in header).

I will do this in "Edit Mode" where the user shouldn't be able to change records and must press a button to get out of that mode.

If there's a better way to do this, I'm interested in that too.

Thanks for all answers,

Lou

 

[danvlas]

This will lock all existing records in the detail section and will unlock a new record.

Sub Form_Current()
Dim ctr As Control
On Error Resume Next
For Each ctr In Me.Section(0)
ctr.Locked = Not NewRecord
Next
End Sub

Good luck,

Dan
Daniel Vlas
Systems Consultant

 

[danvlas]

Sorry, forgot the collection:

Sub Form_Current()
Dim ctr As Control
On Error Resume Next
For Each ctr In Me.Section(0).Controls
ctr.Locked = Not NewRecord
Next
End Sub

Daniel Vlas
Systems Consultant

 

[illuzioner]

Hi,

Thanks for answering. Unfortunately this only locks the controls -- which are already locked.

I'm trying to prevent the user from changing the current record to a different record -- not the values in the record, but changing which record is current.

thanks,

Lou