-Model (this is in a query as it has been split from other data using the InStr and left function)
I have created a relationship between the 2 model fields in the query and table in query2:
Which has the following fields:-
Then I changed the view to data sheet the message box appeared saying “Invaild procedure call” and all data in the fields is changed to “#Name?”
Can someone please help me out cause I really need to solve this problem ASAP. Or is there another way to match these records.
Thank you; any help will be much appreciated.
SELECT Table2.Manufacturer, Table2.Price, Table2.Deal, Table2.Model, Table1.picture
ON Table1.Mode = Mid(Table2.Deal,InStr(Table2.Deal," on ")+4,InStr(Table2.Deal," (")-(InStr(Table2.Deal," on ")+4))