dlook up

[mendesj1]

Me.TotalDelta.Value = DLookup("Currentdelta", "dbo_Futurescompositevalues", "Futcompid = Me!Combo58")

currentdelta is a colum in a linked table dbo_Futurescompositevalues want to get the value of the currentdelta where futcompid =me!combo58 which is a combo box that has the futcompid id

 

[vbaInet]

Is the Row Source of the combo box also dbo_Futurescompositevalues?