How to get form to show values that cannot be edited?

[boundfree]

For example:

I have a database in which I track crates.

Depending on the item, the crate size is different.

I want to make a form that will allow you to select the item, and then display the crate size, but I want it to be impossible to edit the crate size.

How could I do this?



boundfree

[dwmackay]

Sounds like you may want to use either a List Box or Combo Box. In either case, in the property settings, you can "Limit to List" which will prevent the user from entering invalid data.

How you set that up kind of depends. If you have Item #1 that always uses Crate #7, you can simply create a table that matches the items and crates correctly. In that case, no list box is needed; just display the Crate size in an un-editable control chosen from the matching table.

If you want the user to choose the Crate size based on the item, you may want to create a query that includes all of your crate sizes, but limits the list to acceptable sizes depending on the item in question. In that case, the Query would be the source for the List box or Combo Box. This presumes that somewhere along the way, you have defined which crates can be used with which items.

Doug M