I am not really sure if this is what you are looking for but this is the infomation for the supplier fieid.
SELECT [Suppliers Extended].[ID], [Suppliers Extended].[Supplier] FROM [Suppliers Extended] ORDER BY [Supplier];
It is set up that way. It has actually been working great for over a year now. But for some reason it is now causing my problems. It just started giving me the error code and this is the only difference I can see in the table. Shouldn't the be table be exactly like the front end table?
I am using 2007. I already did Compact and Repair but did not make a copy of just the be. I have a table in the back end for my inventory. One of the fields is for supplier. It is set up so the supplier name shows not the auto number assigned to it. For some reason it is now showing the...
I am very new to Access and I am not a programmer at all. Something in my program changed and I am stuck on how to correct it. When I look at the front end everthing looks fine. When I look at the back end one of my fields are no longer reading correctly. I get the message error code 2465