Can this be possible

[Albilly]

Hi,
it has been too long for me with MSAccess and I have a problem
I have taken over some old db from another developer.
I want to know if this is possible, there is a form in READ mode only for some security reason (this form is used as a browser). One request is to add a cbo to be able to filter the data on the form. Is it possible to add a control that can be edited when a form is completly locked down ?
I have tried the following :
If Screen.ActivefORM.Name = "CONFORMITE_HISTO_LISTE" Then
Screen.ActivefORM.Controls!cboFiltreMois.AllowEdit = True
End If

bit getting error 438, object does not support this method or property...

BTW, this control is in the form header

Many Thanks

 

[BitsOfBytes]

I am sure someone will have a better solution, but you could just keep the form locked down. Create a button labeled 'filter' or something. That button could open a form that is not locked and that contains your combo. Once you select your choice the after update event could refresh the records on your locked form and close your filter form.

 

[Albilly]

Thanks,

I just went the older way meaning keep all the data fields locked and just change the form to edit only, that does the job too