Variable name in DLookup (1 Viewer)

[echorley]

Can I use a variable for the expression in a DLookup function?

For example, I would like to use the value from a textbox to determine which field is used:

myStart = Me.CurrentStartPoint

Mileage = DLookup("['myStart']", "MileageChart", "[Finish] =" _
& Forms![frmDailyMileage]!myFinishPoint)

 

[wazz]

i think for this there could be a few "issues". but to try do the job, try to get the value you need from a query first to see if it's possible.

put your mileagechart table in the query grid, add the CurrentStartPoint field and Finish field, add the criteria (Forms![frmDailyMileage]!myFinishPoint), open your form and test the query. do you get only one row in the result? if you can somehow get the result you need from your query, use the query as your lookup source.

Mileage = DLookup("CurrentStartPoint", "qryGetStart")