I'm running a report and get the data from a query, the query shows the correct data as does the combo box on it's own (whioch I don't want), but when I add ="some text " & [field] to the control source in the unbound field it shows the ID, what is going wrong here?

Thanks Ian

When it does that I can almost guarantee that you have used a LOOKUP at TABLE level (see here for why you should NOT do that (http://www.mvps.org/access/lookupfields.htm)). You should only use lookups at FORM level, not set them in the fields at table level.

Hi Bob

Thanks for that, it now works by removing the lookup in the table, in the form making a combo box to look up the appropriate table (with no ID field) and store that data in the required field in the main table and the unbound field shows the correct info.

Also I can run a separate query where I then add both tables, make a join and show other information in the 2nd table that is linked to that number.

I presume that is the correct way (even though it works it may not be the best way for future development??)

Ian