Lookup tables

[rdev]

I created a table with called tblShipmaster .In this table , I have few fields namely :

vessel_type
Reg_country
Hull_type

I have created separate tables (like tblvessel, tblhull,tblcountry) to keep the strings/values for each of vessel_type( like cruise ship,military ship, cargo ship etc) ,Reg_country,Hull_type .

To enter the values of the fields vessel_type, Reg_country, Hull_type, in the table tblShipmaster ,I have created lookup , display control : List box and row source reading
[SELECT Shipclass.Vessel_type FROM Shipclass ORDER BY Shipclass.Vessel_type; ]

I am calling through the query different fields from different tables. I am also calling the vessel_type , Reg_country and Hull_type. The problem is that the user can change the values for these fields using the drop down values . How can I prevent these, I do not want someone to be able to change these. Only the fields I want to change can be changed.

Please help , am novice to Access

 

[xenou]

Look around for properties in the control or form that say:

Allow Edits
Allow Deletions
Allow Insertions

and so on...set these to "False"

Also,
If you see a recordset property, set it to "Snapshot" rather than "Dynaset" - this makes the control/Form read only.

Finally,
List or comboboxes sometimes have property that lets the user enter values not in the list...if you see anything like that, set it to "False" also....

Hope these ideas help...I'm really just thinking out loud. You usually get to these property by right-clicking. Depending on what is the selected object (form, control, etc.) you should see an option to view its properties.


Alex.