lookup columns

[Guest]

I'm creating a brand form for a database. It's a basic 3 table db with the
correct relationships. The data has already been entered through the table.
There are two lookup 1. column for prefixes: Mr., Ms., etc... and 1 for
languages (2 options only) While I know that some people dislike look-up
columns, there are limited options in these columns and I am reluctant to
remove them.

The problem lies in the columns. The selected data in the table does not
always make it to the form. If there is no selected information in the table,
then the form fills in the first item in the column. As well, I have found
some errors e.g. Ms. Suzanne Smith will show up in the form as Mr. Suzanne
Smith.

I'm now on Access 2003 butI've never had this problems with previous
versions.

Any ideas on why the form isn't picking up this information from the table
and how I would fix it?

Thanks in advance

 

[Jeff Boyce]

Christine

If by "lookup columns" you mean you've used the Lookup data type in defining
your table, there's a good chance that confusion about what is stored vs.
what is displayed is what's messing with your form.

What do you get if you only run a query against the table? Are you seeing
the values you expect for those "lookup columns"?