DLookup works once

[RMires]

I am using the following to find volumes from a table when inputing a gauge
(from a storage tank) on a form:

=DLookUp("[Volume]","tblStrap2612","[Gauge]
=[Forms]![frmStrap2612]![InputGauge]")

This works...once. If I change the number in the textbox control
"InputGauge" on the form, the result stays the same. I have tried the
following:

=DLookUp("[Volume]","tblStrap2612","[Gauge] ="
&[Forms]![frmStrap2612]![InputGauge])

but then I recieve an #ERROR

 

[Ofer]

Where did you locate the Dlookup statement?
If it is in the control source of the field then
=DLookUp("[Volume]","tblStrap2612","[Gauge] = "&[InputGauge])

Unless the Gauge field type is string, then try
=DLookUp("[Volume]","tblStrap2612","[Gauge] = '" & [InputGauge] & "'")

The Me.InputGauge.Requery mean
Me = Current form
InputGauge = The name of the field in the form you refer to
Requery = Activate the Dlookup again


--
\\// Live Long and Prosper \\//
BS"D

=DLookUp("[Volume]","tblStrap2612","[Gauge] = [InputGauge]")

Works, but =DLookUp("[Volume]","tblStrap2612","[Gauge] = "&[InputGauge])
gives me the same error. What is the Me in the Me.InputGauge.Requery
expression? It tells me that it doesn't recognize the Macro "Me"

Try

=DLookUp("[Volume]","tblStrap2612","[Gauge] = " & [InputGauge])

And you can try and refresh this field when the InputGauge changes, on the
after update event of the field, write

Me.InputGauge.Requery

--
\\// Live Long and Prosper \\//
BS"D

I am using the following to find volumes from a table when inputing a gauge
(from a storage tank) on a form:

=DLookUp("[Volume]","tblStrap2612","[Gauge]
=[Forms]![frmStrap2612]![InputGauge]")

This works...once. If I change the number in the textbox control
"InputGauge" on the form, the result stays the same. I have tried the
following:

=DLookUp("[Volume]","tblStrap2612","[Gauge] ="
&[Forms]![frmStrap2612]![InputGauge])

but then I recieve an #ERROR

 

[Ofer]

Try

=DLookUp("[Volume]","tblStrap2612","[Gauge] = " & [InputGauge])

And you can try and refresh this field when the InputGauge changes, on the
after update event of the field, write

Me.InputGauge.Requery

 

[RMires]

=DLookUp("[Volume]","tblStrap2612","[Gauge] = [InputGauge]")

Works, but =DLookUp("[Volume]","tblStrap2612","[Gauge] = "&[InputGauge])
gives me the same error. What is the Me in the Me.InputGauge.Requery
expression? It tells me that it doesn't recognize the Macro "Me"

Try

=DLookUp("[Volume]","tblStrap2612","[Gauge] = " & [InputGauge])

And you can try and refresh this field when the InputGauge changes, on the
after update event of the field, write

Me.InputGauge.Requery

--
\\// Live Long and Prosper \\//
BS"D

I am using the following to find volumes from a table when inputing a gauge
(from a storage tank) on a form:

=DLookUp("[Volume]","tblStrap2612","[Gauge]
=[Forms]![frmStrap2612]![InputGauge]")

This works...once. If I change the number in the textbox control
"InputGauge" on the form, the result stays the same. I have tried the
following:

=DLookUp("[Volume]","tblStrap2612","[Gauge] ="
&[Forms]![frmStrap2612]![InputGauge])

but then I recieve an #ERROR

 

[Ofer]

Sorry, I forgot one thing

When you are on the After update event of the InputGauge field, you can see
a button on the right with three dots, click on it, and select code view, and
tere you can put the code

Me.[insert here The Field name where the dlookup is in].Requery
--
\\// Live Long and Prosper \\//
BS"D

=DLookUp("[Volume]","tblStrap2612","[Gauge] = [InputGauge]")

Works, but =DLookUp("[Volume]","tblStrap2612","[Gauge] = "&[InputGauge])
gives me the same error. What is the Me in the Me.InputGauge.Requery
expression? It tells me that it doesn't recognize the Macro "Me"

Try

=DLookUp("[Volume]","tblStrap2612","[Gauge] = " & [InputGauge])

And you can try and refresh this field when the InputGauge changes, on the
after update event of the field, write

Me.InputGauge.Requery

--
\\// Live Long and Prosper \\//
BS"D

I am using the following to find volumes from a table when inputing a gauge
(from a storage tank) on a form:

=DLookUp("[Volume]","tblStrap2612","[Gauge]
=[Forms]![frmStrap2612]![InputGauge]")

This works...once. If I change the number in the textbox control
"InputGauge" on the form, the result stays the same. I have tried the
following:

=DLookUp("[Volume]","tblStrap2612","[Gauge] ="
&[Forms]![frmStrap2612]![InputGauge])

but then I recieve an #ERROR