get a value from a field in a query and store it in a variable 2

[act2]

I’m trying to get a value from a field in a query and store it in a variable using VB. I’ve tried many suggestions from the post but noting seems to work. The query is called qryReportGen and the field within the query is JobHr . Thanks

 

[PHV]

Have a look at the DLookUp function or at Recordset.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MajP]

Like PHV said. Something like
Dim intJobHr as integer
dim strWhere as string
strWhere = "something here"
intJobHr = dlookup("JobHr","qryReportGen",strWhere)

The strWhere is a where statement without the word "where" in it. Maybe something like

strWhere = "JobID = " & me.txtBoxJobID

 

[act2]

PHV and MajP thanks for your help. Worked great