Combo boxes in a Read Only form

[obheron]

Is it possible to use Combo Boxes (i.e. get them to update) in a read only form?

I have them in a form that has edit capabilities and when you close the form it says changes were not saved because the primary key does not allow duplicates (something like that).

I don't want changes to be made I only want the form to be used as a search tool. Is there a way to avoid having the not saved error message from popping up?

Thanks

 

[PHV]

In the Unload event procedure of the form:
If Me.Dirty Then Me.UnDo

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[obheron]

In the Unload event procedure of the form:
If Me.Dirty Then Me.UnDo

Are you suggesting to do this in the edit mode?

I tried this and I still get the error message.

Onto something else....

 

[obheron]

Figured out a way aroud this also. I removed the Control Source for the objects. The RowSource still populates the object, and with no control source the form doesn't try to edit the tables.