Creating a form that is read only, but that will allow a search...

[Guest]

Good morning everyone

Could anyone with half a computer brain (I don't even have an eighth of a
computer brain!) help me with this MS Access query:

I am designing a simple document management database. Nothing flash - I just
want it to allow everyone to input their documents when they've drafted them
and also allow everyone to do a search for a document by the Author's name.
The only stipulation is that I also want the form to be 'read only' so no one
apart from me can edit information that's in there. Now I know how to set the
form to 'Read Only' and i've done this. I've also created a button that
allows me to change the form to 'edit' mode, so that I can make alterations
where necessary. But my problem is this: whenever the form is in 'read only'
it prevents anyone from going to a document via the drop down box on the
form! Is there any way around this? I've fiddled with all sorts of buttons
and visual basic code but got nowhere.

In short - is it possible for a form to be 'read only' but to allow searches
via a combo box on the form?

Thanks for your time on this - hope i've got the right forum!

David

 

[Rick Brandt]

Good morning everyone

Could anyone with half a computer brain (I don't even have an eighth
of a computer brain!) help me with this MS Access query:

I am designing a simple document management database. Nothing flash -
I just want it to allow everyone to input their documents when
they've drafted them and also allow everyone to do a search for a
document by the Author's name. The only stipulation is that I also
want the form to be 'read only' so no one apart from me can edit
information that's in there. Now I know how to set the form to 'Read
Only' and i've done this. I've also created a button that allows me
to change the form to 'edit' mode, so that I can make alterations
where necessary. But my problem is this: whenever the form is in
'read only' it prevents anyone from going to a document via the drop
down box on the form! Is there any way around this? I've fiddled with
all sorts of buttons and visual basic code but got nowhere.

In short - is it possible for a form to be 'read only' but to allow
searches via a combo box on the form?

Instead of opening the form read only, use a RecordSourceType of Snapshot. That
will make the RecordSource read only without affecting unbound controls on the
form.

 

[Rick Brandt]

Did you mean RecordSet Type of Snapshot?

Yes, sorry.