Prevent update except by button

[Jeff]

Hi All,

I have a mainform with two mainform controls: sbfList and sbfDetails.
fmsList is a list of student names and when clicked on, filters the
other subform sbfDetails.

I want the details in sbfDetails to only be updated by a button on
sbfDetails. At the moment, if I click on the list in sbfList, the
details are updated automatically. I'd like to force it not to update,
only when the update button is pressed on the sbfDetails.

Any ideas greatly appreciated,

Jeff C.

 

[Arvin Meyer [MVP]]

Use unbound forms and write the data on the button's click event.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access