prevent design view

[Guest]

Hello All,

I have a form that opens from my switchboard. I only want the users to view
the data from the "Form View." How do I hide "Design View?"

Also, how can i prevent the users from editing the data that is already
stored in the table (the table is updated via the same form mentioned above).
I want the user to be able to add new records but not edit the existing
records.

Thanks for the help1

 

[Guest]

To keep the users out of design mode, create an MDE file for them and don't
allow them access to the MDB. The answer to the other question depends on
how your form works. How do you know when they are looking at existing data
as apposed to entering new data? I can give you an answer once I have that
info.

 

[Guest]

Klatuu,

I have a switchboard that directs the user. On the switchboard, the user
can select: View existing data, Modify existing data, Enter new Data.
Therefore, if they select "view existing data," I only want them to see that
data, not modify it.

 

[Nikos Yannacopoulos]

HL,

If you look at the code behind the command buttons, there should be a
line in each that looks like:

DoCmd.OpenForm stDocName, , , stLinkCriteria

The next optional argument in the OpenForm command is the one that will
do the job for you. Modify this line to:

DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormReadOnly

for the View button; likewise, use arguments acFormEdit and acFormAdd
for the other two.

HTH,
Nikos