Find Record Combo Box

[Guest]

I am using the Access Wizard to create a Find Record Combo Box. It was
working fine until I tried to set the Form OnCurrent event = AllowEdits =
False in order to open the form in read-only mode. Ever since then, even
though I have removed the AllowEdits = False, I am not able to select the
record from the combo box, The combo box acts as if it has an event that does
not allow editing.

I am using Access 2K. Any help would be greatly appreciated.

 

[Van T. Dinh]

The setting of AllowEdits = False might have been saved in the Design of the
Form.

Open the Form in DesignView. Open the Form's Properties window and move to
the "Data" tab. Check to ensure that the "Allow Edits" Property is set to
Yes / True.

You should also check to ensure that the ComboBox Property "Enabled" is set
to Yes and "Locked" is set to No.

 

[Guest]

OK changing the AllowEdits property on the form did the trick. My question
now is, I want the form to open in read only mode, but I also want the Find
Record combo boxes to work. I have already added a command button to allow
edits, but I don't want to have to use the Allow Edit command button just to
search for a record.


Thanks

 

[Van T. Dinh]

You cannot use the Form's AllowEdits in this case.

You need to set the Locked Property to True (and preferably Enabled to
False) of other editable Controls on the Form. In the cmdEdit_Click Event,
change Enabled to True and Locked to False.

 

[Guest]

Thanks Again. 1 more question. Is there a way to programatically make these
settings? I have about 50 editable controls on the form on 6 tab control
pages to reset. I could brute force it and enumerate each control, but I
should think there might be a better way using some sort of looping
mechanism, I'm not sure where to start however.