Are that sound's better, what do i need to include the the AUID and the filed from the small table and the field from the main tabel, and then link the field to the forms unbound boxYou only need to use a combo if you want to update the field by choosing from the list. If you simply want to display the text value as you would in a report, use a query that joins the main table to the lookup table (use a left join if the lookup field is optional). Then select the text value from the lookup table and bind it to a textbox to display. Make sure to LOCK the text box because you don't want anyone to accidentally update the lookup value.
I just joined the field in the control source and its cumming up #Name? i don't think the query is right