Option Group in a Protected Form

[Antonio via AccessMonster.com]

Hello,

I have a sub-form in which I only want users to browse data. The "Allow
Edits", "Allow Additions" and "Allow Deletions" properties are therefore set
to "No".

I've added an option group and a command button (pointing to a report), so
that I can filter the results in the report.

Problem is, I can't switch between options in the option group, because of
the "Allow Edits" properyt, set to No.

Anyone?

Thanks
Antonio

 

[SusanV]

Hi Antonio,

If only the subform is locked, can you move the option group out to the main
form?

Just a thought,

Susan

 

[Antonio via AccessMonster.com]

Hello Susan,

That's an idea, the problem is it will compromise my graphical layout
The main form is just a little space with the Employee ID and Name...

Antonio

Hi Antonio,

If only the subform is locked, can you move the option group out to the main
form?

Just a thought,

Susan

Hello,

[quoted text clipped - 13 lines]

Thanks
Antonio

 

[SusanV]

I hear you - layout once designed it's no fun to redo, especially if
screenspace is at a premium
;-)

Another option would be to unlock the subform itself, and go through and
lock all the individual controls other than those you want users to be able
to "play with" - such as your option group. If you have a lot of controls
this may be tedious but would get you the results you want.
--
hth,
SusanV

Hello Susan,

That's an idea, the problem is it will compromise my graphical layout
The main form is just a little space with the Employee ID and Name...

Antonio

Hi Antonio,

If only the subform is locked, can you move the option group out to the
main
form?

Just a thought,

Susan

Hello,

[quoted text clipped - 13 lines]

Thanks
Antonio

 

[Antonio via AccessMonster.com]

You're right!
Yes, I've done what you suggested and it works neat, thanks.
Can your email/msn?
Antonio

SusanV wrote:
I hear you - layout once designed it's no fun to redo, especially if
screenspace is at a premium
;-)

Another option would be to unlock the subform itself, and go through and
lock all the individual controls other than those you want users to be able
to "play with" - such as your option group. If you have a lot of controls
this may be tedious but would get you the results you want.

Hello Susan,

[quoted text clipped - 18 lines]

 

[SusanV]

Glad to help!

No chat here at work (I block it at the firewall or no one gets anything
done, lol)
Email - Remove the"nospam-" from [email protected]
--
hth,
SusanV

You're right!
Yes, I've done what you suggested and it works neat, thanks.
Can your email/msn?
Antonio

SusanV wrote:
I hear you - layout once designed it's no fun to redo, especially if
screenspace is at a premium
;-)

Another option would be to unlock the subform itself, and go through and
lock all the individual controls other than those you want users to be
able
to "play with" - such as your option group. If you have a lot of controls
this may be tedious but would get you the results you want.

Hello Susan,

[quoted text clipped - 18 lines]

Thanks
Antonio