Hi, Ok thanks everyone so far for your help it's been great.

How do I get around combo boxs in order to show field names values from other tables on my forms.

I want to be able to display some values on some forms showing vaules from other tables without havinbg to use combo boxs. Everyting I tried hasn't worked. The only thing that will display my field correctly is the combo box but I don't always want the field to be such.

If you use joins in the queries used to build your forms and reports, you can include data from related tables without using comboboxes. Just make sure to lock the fields to prevent updating.