linked field is always editable - don't want that

[russi]

Hopefully I can explain this properly.

I have a main form from a table with a primary key of IDNUMBER. I have a subform with IDNUMBER from another table that is linked to the first table in a one-to-many relationship. I have a separate screen that allows the user to enter someone's IDNUMBER and the main & subform appear.

Everything works fine, EXCEPT
** when the user finishes entering data in the main form and is brought into the subform, even with IDNUMBER w/property of Locked=YES, that field becomes editable or changes to all zeros.

I need the user to simply see correct the IDNUMBER in the subform and be able to enter data on it and on leaving, have the main form AND subfrom data saved.
MAKE SENSE?
thanks.

 

[R. Hicks]

Set the IDNUMBER "Locked" property to "Yes" and the "Enabled" property to "No". This will keep the user from being able to access the txtbox.

HTH
RDH

 

[russi]

Thanks for idea, but it doesn't work for some reason.
Only if the user answers the last field on the main form then clicks past the IDNUMBER on the subform and into the next field is it okay, BUT if they use tab or enter key as they usually do, the cursor jumps past the IDNUMBER and into the next field, but the numbers become all zeros?

 

[russi]

You WERE RIGHT! (But you probably knew that anyway.)

I FORGOT that I would need to delete the subform from the form and then re-add it after making the change you suggested to the field., before the change would take effect, there.

It works fine, now.
THANKS!

 

[BarkerD]

Why would you need to delete the sub-form and then add it to make changes?

Sounds a little buggy to me.

 

[R. Hicks]

You should only need to have made the changes in the form that the subform is based on.

HTH
RDH

 

[russi]

Now you folks have me puzzled. After putting in the change, it still did not work. Only after deleting the subform from the screen and re-attaching it, did the change work. (???)