Field Security

B

BradleyJ

I have a contact db with a main contact frm. Each contact may give a gift. In the contact frm I have a cmd button to open a gifts frm. In the gifts frm I have a giftid(pk in gift tbl) and contactid to confrim that these two fields in both frms match. I have found that the contactid field in the gifts frm can be altered. I don't want that. The giftid field (which is the pk and cannot be changed), I would like the contactid field to behave like the giftid field. How can I secure the giftid field? I hope this explains my situation.
 
V

Van T. Dinh

Not sure from your description but try setting Enabled = se and Locked =
True Falfor the Control that is bound to the Field "ContactID ".

--
HTH
Van T. Dinh
MVP (Access)



BradleyJ said:
I have a contact db with a main contact frm. Each contact may give a
Click to expand...
gift. In the contact frm I have a cmd button to open a gifts frm. In the
gifts frm I have a giftid(pk in gift tbl) and contactid to confrim that
these two fields in both frms match. I have found that the contactid field
in the gifts frm can be altered. I don't want that. The giftid field
(which is the pk and cannot be changed), I would like the contactid field
to behave like the giftid field. How can I secure the giftid field? I hope
this explains my situation.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I hightlight field when criteria met? 8
Transpose data in a report-Field values broken down to separate co 9
Syncronizing Generic Subforms 1
Form processing with If (still looking for answer) 3
How do I copy a value from one form to another? 1
Auto completion 1
Adding a Range of numbers from form to a table 2
how do I open a new form with a cmd button using data in current f 12

Top