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?

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).]