Configure a Comb Box to be read-only in a form

[ZodiacPilot]

I have an access 2013 database that contains two forms for data. One form is the Edit form which is read-write and
and the other form is Query which shows the values only. I created a combo box in the Edit form in which I have a list that is displayed for selection. When I switch to the Query version, all fields are read only except the combo box I created. It is still allowing the data to be changed. I access both forms from a Task Manager form which has two command buttons Query Edit


All responses are greatly appreciated.

[Ruegen]

You can define a control's property (the combo box is a control, and the control has a list of properties) by lock property or limit to the list

http://stackoverflow.com/questions/1...in-access-2000

[June7]

One form can serve both purposes.

If the form is opened with acFormReadOnly parameter then no data can be edited.

Docmd.OpenForm "form name", , , , acFormReadOnly

If you have a form for only viewing, then why is there a combobox? It has a lookup with alias? Instead of combobox, include the lookup table in the form's RecordSource.

[ZodiacPilot]

I have the form working correctly in read/write and query for all combo boxes except the one I created. If I set "yes" to the lock definition, the edit/update form view will not allow for any selections. I am not using a alias lookup and I do have the lookup table defined in the form's RecordSource.

[June7]

I am confused. Do you have one form or two forms?

[ZodiacPilot]

I have a single form. I have two command buttons. one is query and one is edit.

[June7]

Did you try the acFormReadOnly parameter for opening the form as read only?

[ZodiacPilot]

Yes, it is defined in the vb script.

[June7]

Then all data controls should be not editable.

If you want to provide db for analysis, follow instructions at bottom of my post.

[ZodiacPilot]

Here is my database ........ thanks for your help in advance.

[June7]

There aren't any forms in that db.

[ZodiacPilot]

The zipped database with folders in 4.5MB. How can I send it to you?

[June7]

This is a split design? You only posted backend? The frontend is 4.5MB zipped? One way is to copy frontend and delete objects not needed for the issue.

Otherwise can upload to a fileshare site such as Box.com and post link to file. However, I have problems downloading large files (weak internet at home).

[ZodiacPilot]

I am going to send the file via citrixShareFile. Is this the e-mail address for you?

http://www.cpearson.com/excel/debug.htm

[June7]

No, that is not my email. That is just an information link I reference. I do not post my email to forum.