variable as field name in dlookup help

[vbaInet]

I would rather not import from excel, but in this pricing table instance its going to be around 436 different prices per customer per jobsite and that equates to a lot of data entry on a form if i have to manualy input from a printed excel spreadsheet.

In that case a tedious Import routine will need to be created to plug in the records into the correct tables and also maintaing referential integrity. It's not going to be easy.

No problemo! Happy to help and good luck.

 

[josephff]

http://www.access-programmers.co.uk/forums/showthread.php?p=1125711#post1125711