How to prevent changes in a main table

[paliman]

Hi everybody.
I’ve made a database with the following tables (among others):

ACCOUNTS
AccountCode
ShortAccountCode (key)
AccountName


DIARY HEADERS
NumberAD
Date
Header

DIARY DETAIL
Id (autonumeric – key)
NumberAD (related to the one on the previous table)
ShortAccountCode (related to accounts table)
Debit
Credit

Then I need a form to input daily movements. I want to type the Short code and I want access to show me the account name when I type it. So I made the following query:

Table Field
Diary detail ShortAccountCode
Accounts AccountName
Diary detail Debit
Diary detail Credit


and used this query to create a subform. The account code is a 12 digit code while the short code is alphabetic and has 4 places. It’s intended to make data input easier.
Now I am in my subform, I type the short code and the account name appears, so the user can check if he or she is doing any mistakes. That is fine. The problem is that the ACCOUNTS table (which is a master table) can be modified from this form. And I don’t want to. I need access to deny any modifications from here.
Any suggestions?
May be a better way of making my form?
Should I try with permissions by users?

Many thanks in advance.

 

[Jerry Stoner]

Account is the main form right? Just set the record locks property to All Records. You should then be able to enter data in your su
bform but not your main form.
HTH,
Jerry

 

[paliman]

Thank you guys. It was exactly what I wanted