As a relative Newbee to access I wonder if anyone can help me.

I am trying to run a query from an orders database with the suppliers names in a combo box.

When the query runs it does not retrieve the supplier's name but displays a number. I'm not even sure where this number is retrieved from as it is not the SupplierID number in the underlying table.

I'm sure that the problem can be resolved easily but I don't have the knowledge skills to resolve it.

any help would be greatly appreciated

BJDixon :confused:

Any chance you have a LookupField (http://www.mvps.org/access/lookupfields.htm) in your table?

Hi Rural Guy,
My apologies , I forgot to mention that. I have indeed gor a lookup field in my table. It is a table consisting of Suppliers Names which is displayed in my Combo box refers when completing the order form.

Perhaps these will help:

http://www.btabdevelopment.com/main/QuickTutorials/HowtoRemoveLookupsatTableLevel/tabid/141/Default.aspx

http://www.btabdevelopment.com/main/FullTutorials/Howtousequeriestogetyourlookupvalues/tabid/134/Default.aspx

Thanks for the pointers I'll spend some time examining them

That 2nd tutorial is a dilly Bob. I had not seen that one before. Great Job.

That 2nd tutorial is a dilly Bob. I had not seen that one before. Great Job.

Thanks Allan.

I have to spread my points around before I can give you any more. I don't do that enough.

Bob,
Thanks for your help and your tutorials. Worked a treat

BJDixon