Hi all, I have a table called job Info, that has columns that are updated from combo boxes on a form. The form is a setup sheet that we can fill out for each job we do which has job Name, Drawing numbers and links to drawings, cycle times, tools used etc. the info for the list of tools is gotten from 3 linked tables which contain toolbrand, Toolname, and any bits that go with this tool like spare parts. It works up to this point. I now want to make a new form for when a job comes up again that we can view this data but not be able to change the data. Some info being entered doesn't need to be seen again by the machinist after initial entry so to declutter the screen I want a form to just view certain info. So on the new form I have a combo box to call the job name which changes the record number to the correct number. I then have a text box that I have entered in the control source =cbotoolname.column(2). It looks like this works as it is supposed to but because the table info where combo boxes have selected the data, my text box only shows the ID of the entry. Is there anyway around this.
Thanks