Form to view data with combobox

[Vulcan1500]

I have a form to view data. For that reason I do not allow edits, deletions, additions and I have also set data entry to no. In the footer I have a combobox of one of the datafields on the form. To type and/or select a value I want the form to be filtered for that value. Due to the settings of the form I'm not able to edit the combobox. How can I change these settings for the combobox only?

 

[boblarson]

Unfortunately setting Allow Edits to NO has also locked your combo. Instead, set them to YES and then in each control that you do NOT want to allow edits, set these:

Locked = YES
Enabled = NO

 

[namliam]

By making the Combobox be part of a main or subform to the form you want to be searching on...

These properties are on form level, so can be set differently for sub and main forms.

Good Luck!

Edit: Xpost with Bob, Hi Bob !

 

[Vulcan1500]

Hi Bob. Did what you suggested (except setting enabled to no). This does the job, but raises another question. In the form I have fields and pending on the selection in the field it might deactivate other fields. This is now lost. Correct and, if so, is there a solution?

 

[missinglinq]

These properties are on form level, so can be set differently for sub and main forms.

Actually, you can't, Mailman. The AllowEdits/AllowAdditions/AllowDeletions property settings for the main form are inherited by its subforms, regardless of how they are set in the subforms. Locking/Disabling individual controls, as Bob suggested, is the only way to do this.