Read only form problem - take 2

[Louise]

Thanks for the suggestion.

Unfortunatley, although the requery is only based on 2-3 combos, there are around an additional 40 or so text fields or other combos on the form. I would rather not have to select each individually and set Enabled to No and Locked to Yes.

Is there something I can put in the code so that it retains the no edits etc properties of the form?

 

[R. Hicks]

Change the form's Recordset Type from Dynaset to Snapshot.

Or open the form using the OpenForm method:
DoCmd.OpenForm "yourFormName", , , , acFormReadOnly

Maybe this will help,
RDH

[This message has been edited by R. Hicks (edited 04-12-2000).]