Hi this is my first post so if theres something hediiously wrong i apologise.

Right the problem im having is i need my data base to be able to use a lookup function (such as Dlookup) to find a certain number its very hard to explain. There are seperate parts of the look up table as well, there are multiple coloums and it needs to be able to recognise which one it has to lookup from depending on data kept in the original record.

If that sounds not clear just post about it and ill try to sort it out

Thanks a lot

Andy :)

DLOOKUP(Column,Table,Criteria)
No reason you can't supply the column and table in variables to my knowledge. Of course that means VBA code. You could create a VBA function to return the data to you and use that function as the source for a field in a query or form.

It sounds the DLookup() function can do what you want, as it can look up info by row and field.

Can you give us more detail, especially about the look up criteria and the structure of the look up table?