Lookup tab Problems.

[blacksaibot]

I've designed a database on Access 2007.
On a particular table I have it so users can only enter data via combobox that use a row source from the LookUp tab in the design view.

When I view the table the comboboxes work fine.
When other users try to work with the database and enter data they see the query statement instead of the contents of the combobox

For example:

When I select "2" from a combobox, it stays that way in the table

When some one else selects "2" the field within the table becomes:


SELECT [table_name].[column_name] FROM... etc. etc.

What is going on here? Is it because they downloaded the file and its force as read only mode or edit mode? How can I prevent this?!

[NTC]

"downloaded the file" ??

that certainly raises alot of questions. plz explain what you mean by this.

also, is this database split?