Access 2003 - Form Snapshot

[Orson9750]

I set my main form RecordSet property to Snapshot to prevent edits to the main form and still be able to make edits in my subform. I previously added a Command Button for a Record Find on the main form. My problem now is that my Record find does not work. I use Record Find to locate records in the main form for edits to the subform.

Suggestions as to how to fix this are welcome.
Orson 9750

 

[HiTechCoach]

My problem now is that my Record find does not work.

What does not work? Are you getting an error message?

 

[GuiGirl]

Thanks for replying. No error message. I want to keep the information on the main form in tact so I used Snapshot on RecordSet. I also have a subform on the main form that holds information for each record in the main form.To find the record to update I use a Record Find command which is part of the main form hence my Record Find command now does not work. My need is that I protect my main form but still have the ability to use a Record Find and be able to update in my subform. Is there a way to avoid edits to the main form but still be able to update in the subform?

 

[HiTechCoach]

Are you saying that just by changing the main form's recordset back to a Dynaset (or something updatable) that it works correctly in the sub form?

 

[Orson9750]

Yes. I changed the RecordSet Type back to Dynaset to make my updates to the subform. If there is a way to protect the main form but allow updates to the subform?

Thanks for your help
Orson9750

 

[HiTechCoach]

Yes. I changed the RecordSet Type back to Dynaset to make my updates to the subform. If there is a way to protect the main form but allow updates to the subform?

Thanks for your help
Orson9750

On the main form, set all the control's property for Locked to Yes that you do not want the uses to change.