Blocking changes

[John Keith]

I have a form that uses unbound textboxes to enter search criteria in the
header-section. Matching rows are filtered to the detail-section.

I want to prevent any changes from being made to the detail rows. When
clicking on a row, this event will then pass the key of that row to some
other process either external(mainframe macro generator) or internal(another
form).

I have tried making the form non-editable: the problem is that the unbound
controls where search critera is supposed to be entered also are locked.

I made the linked table point to the text version instead of a true-access
table of that data. This works but the responce time is so bad that it will
not work.

I am trying to catch the change in the field_change routine, but the
original value that I expected to be in the OldValue property is already
updated to the new.

What are some other possibilities?

 

[Jeanette Cunningham]

John,
You can lock each control in the detail section.
This leaves the form in edit mode, but users can't change the value of any
locked controls.
To lock a control, go to the Control's property dialog | Data tab | Locked

Jeanette Cunningham

 

[Marshall Barton]

I have a form that uses unbound textboxes to enter search criteria in the
header-section. Matching rows are filtered to the detail-section.

I want to prevent any changes from being made to the detail rows. When
clicking on a row, this event will then pass the key of that row to some
other process either external(mainframe macro generator) or internal(another
form).

I have tried making the form non-editable: the problem is that the unbound
controls where search critera is supposed to be entered also are locked.

I made the linked table point to the text version instead of a true-access
table of that data. This works but the responce time is so bad that it will
not work.

I am trying to catch the change in the field_change routine, but the
original value that I expected to be in the OldValue property is already
updated to the new.

Cann't you just set the detail text boxes' Lock property to
Yes?

 

[Larry Linson]

Or, in addition, you could display the detail records in a form embedded in
a subform control... setting that form to no updates, no adds, and no
deletes should accomplish your purpose without blocking use of the unbound
search controls on the main form.

On the other hand, it's probably easier just to select all the controls you
don't want updated and change the locked property for them all with one
click, as you've already been advised.

Larry Linson
Microsoft Office Access MVP

 

[John Keith]

Locking the control is exactly what I needed.

--
Regards,
John

John,
You can lock each control in the detail section.
This leaves the form in edit mode, but users can't change the value of any
locked controls.
To lock a control, go to the Control's property dialog | Data tab | Locked

Jeanette Cunningham

 

[John Keith]

A sub-form probably would work to accomplish the same, but locking the
controls was the silver-bullet.

Thanks for the replys!
--
Regards,
John

Or, in addition, you could display the detail records in a form embedded in
a subform control... setting that form to no updates, no adds, and no
deletes should accomplish your purpose without blocking use of the unbound
search controls on the main form.

On the other hand, it's probably easier just to select all the controls you
don't want updated and change the locked property for them all with one
click, as you've already been advised.

Larry Linson
Microsoft Office Access MVP