RE: Field1 controls what is displayed in Field2

Tech-Archive recommends: Fix windows errors by optimizing your registry

It's me again.

To make your textbox unable to be changed by someone else open your form in
design view, open the Properties ***, click the Data tab, and change Locked
from No to Yes. That's it.

You will be able to see what is in the text box but it cannot be edited.

Hunter57
Just huntin' for some data.
http://churchmanagementsoftware.googlepages.com


"cpocpo@xxxxxxxxxxx" wrote:

Hello,

I asked this awhile back, but am still unsure of what to do:

Is there anyway to have the Field2 automatically entered in the table
when the value for Field1 is selected in the combo box on the form??

In other words, on the form, select "Paperclip" using a combobox which
is tied to Field1. In the next field2 is a listbox (or combo,
whichever works) that would change to say "Part 06207". (It would be
grayed out so no data entry happens there by the user.)

Select "Stapler" in Field1 and field2 changes to "Part 099A"

etc.

??

BTW, is there a site somewhere where we can share Access files so that
I can just modify someone else's format, or they can modify mine
instead of reinventing the wheel everytime??

Appreciate all the good info!

V/R

LostGuy


.

Quantcast