split form with combo box as filters-allowedits false

[Andy74]

Hello Everybody,

I have a simple split form with datasheet on the bottom and a couple of comboboxes (unbound) on the form header which the user can use for filtering the data.

When some users open the form the allowedit property of the form is set to false, because those users can only view the records. But the result is that also the comboboxes cannot be set, hence no filtering!

Is there an easy to overcome this?

thanks

Andrea

 

[burrina]

I'm assuming you have form permissions. You can of course add to the permissions and make available the fields.

HTH

 

[spikepl]

For those users you could set the form's Property-> recordset Type to snapshot (and Dynaset for the others). Snapshot is read only

But it would be more proper, I think, to set the Locked property of each field, according to th eprivileges of the user

@burrina

If you post AND receive comments but then delete the entire thread, then that is an incredibly rude thing to do because you have totally wasted others' time. And that in a post about netiquette!!!!!!!!!!

Think before posting, and live with what you did write.

 

[Andy74]

Thanks for the reply, I think I will proceed with setting the locked propertry on each control, for the users who can view and filter.

Andrea

 

[burrina]

I stand by what I wrote but decided it was not worth the trouble to debate.
My apologies for wasting your time. It won't happen again!

 

[Uncle Gizmo]

I think burrina did the correct thing in deleting the post.

If you are worried about wasting your time why are you here?

 

[vbaInet]

Andy74, if you want to do things properly then you need to do both of what spikepl mentioned, not just one. That is, set the recordset type to Snapshot and locking each control, that's proper read-only.