[mso] Re: Access: Protect one table possible?

Thank you!!!! 


Joomi Lee

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Cathy.Evans@xxxxxxxxx

How is your look-up form set up?  A combo box?  Is the combo box control
source set to a field or unbound with a row source lookup query?  It makes a
difference.  Also, is the bound column (if there is one bound) the one tied
to the ID?  What is the ID structure?  If you are looking up from a form,
yes the table can be protected by locking or disabling the form field.
Offhand, without knowing more, it sounds like the combo box (if that's the
lookup used) is set to a field in the table, which will change the field
data when you select a record. The control source needs to be blank, the row
source query on the combo would be the source of the look-up. hth, Cathy
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: