Recent content by FJM-P

.......Sorted now......thanks for the replies

I found this earlier, but I still can't seem to work out the correct coding.....I tried quite a few combos but with no luck...

I have a main form called SALESORDERNUMBER which contains a subform called DETAILS. On the mainform is a control named TESTNUMBER. This has 2 values to choose from. Either TP25A or TP68 On the subform is a control called STS1 which has a label called label22 I want to make the control and label...

Thanks for moving the thread....appreciated. Not sure about the ODBC driver....how do I find out the version ? Also, any idea why some of the fields in the table are OK but there are 14 which are not ?

I am currently linking several SAGE tables into Access and have done this without a problem for a number of years. SAGE have just done a complete system upgrade and 1 of the linked tables has developed a problem. The SAGE table is dbo.StockItem In my Access database when I use the standard...