ACCESS DLOOKUP trouble

[gheyman]

I am having trouble with this Dlookup

=DLookUp("[WBS_PG_ID]","qryPIDBOE","[PID_Number]=" & [Forms]![frmEstimates]![ComboBOESelectPID])

In the Query named qryPIDBOE I need to grab the WBS_PG_ID where the combobox named comboBOESelectePID on my form named frmEstimates equals the field in the query named PID_Number

Query Name: qryBIDBOE
Query fields: WBS_PG_ID & PID_Number

Form Named: frmEstimates
Combobox: ComboBOESelectPID

 

[stumac]

If the rowsource of the combo box is fields from "qryPIDBOE" then instead of using Dlookup (which should be used sparingly due to how inefficient they are). you should include extra columns in the combo box, set their width to 0 and then pull into another control using =ComboBOESelectPID.column where n is the number of the column (starting at 0).

If not then I don't see anything wrong with your Dlookup provided PID_Number and ComboBOESelectPID are both numeric. if not then try:

=DLookUp("[WBS_PG_ID]","qryPIDBOE","[PID_Number]= '" & [ComboBOESelectPID]&"'")

 

[gheyman]

Thanks, based on your advice and others I am going to avoid a Dlookup