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

[ZodiacPilot]

I have the zipped database file in a folder on ShareFile. How would you like to proceed?

[June7]

Post link to the file. If I can download without having to be a member of ShareFile, will try.

[ZodiacPilot]

You may access the file at: https://WildHorsePreservationLeague.sharefile.com

Loging: john_cline@usa.net
Pswd: Wildhorse1

The file is in the Wildhorse folder

Thanks again for your efforts. It is greatly appreciated!

[June7]

As I said would be case, my home internet is too weak. Won't even load page after logging in. Never had a problem with Box.com.

[ZodiacPilot]

OK, let me see what I can do with Box. Thanks

[ZodiacPilot]

Problem solved. I edited the VB script under both the enter and query form definitions. I inserted the following for both:

For the Query Form definition:

.Bands.BackColor = bgColor
.Bands.Locked = True
.Bands.Enabled = False


For the Update Form definition:

.Bands.BackColor = bgColor
.Bands.Locked = False
.Bands.Enabled = True


I still do not understand why I had to update the script directly? Oh well, it works; and I now know how to do it.

Thanks for your help and I am sure we will be interacting again.

[Missinglinq]

...When I switch to the Query version, all fields are read only except the combo box I created...

...If I set "yes" to the lock definition, the edit/update form view will not allow for any selections...

...I have two command buttons. one is query and one is edit...

So, in the code behind your 'Query' button, use

YourComboboxName.Locked = True

then in your 'allow edits' button use

YourComboboxName.Locked = False

Linq ;0)>