G
Guest
How do you display the results in a textbox from a query in an exit event of
a previous textbox?
a previous textbox?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
fredg
How do you display the results in a textbox from a query in an exit event of
a previous textbox?
Use a DLookUp.
If the query returns just one record:
[ControlName]=DLookUp("[FieldName]","QueryName")
If the query returns more than one record....
If [Somefield] is a Number datatype, use:
[ControlName]=DLookUp("[FieldName]","QueryName","[SomeField] = " &
SomeNumberCriteria)
If [SomeField] is Text datatype use:
[ControlName]=DLookUp("[FieldName]","QueryName","[SomeField] ='" &
SomeTextCriteria & "'")
In VBA help, look up DLookUp
as well as
Where clause + Restrict data to a subset of records.
G
Guest
This worked beautifully ! ! ! Many thanks ! !
fredg said:How do you display the results in a textbox from a query in an exit event of
a previous textbox?
Use a DLookUp.
If the query returns just one record:
[ControlName]=DLookUp("[FieldName]","QueryName")
If the query returns more than one record....
If [Somefield] is a Number datatype, use:
[ControlName]=DLookUp("[FieldName]","QueryName","[SomeField] = " &
SomeNumberCriteria)
If [SomeField] is Text datatype use:
[ControlName]=DLookUp("[FieldName]","QueryName","[SomeField] ='" &
SomeTextCriteria & "'")
In VBA help, look up DLookUp
as well as
Where clause + Restrict data to a subset of records.
A
adsl
krharrison said:How do you display the results in a textbox from a query in an exit event
of
a previous textbox?
A
adsl
fredg said:How do you display the results in a textbox from a query in an exit event
of
a previous textbox?
Use a DLookUp.
If the query returns just one record:
[ControlName]=DLookUp("[FieldName]","QueryName")
If the query returns more than one record....
If [Somefield] is a Number datatype, use:
[ControlName]=DLookUp("[FieldName]","QueryName","[SomeField] = " &
SomeNumberCriteria)
If [SomeField] is Text datatype use:
[ControlName]=DLookUp("[FieldName]","QueryName","[SomeField] ='" &
SomeTextCriteria & "'")
In VBA help, look up DLookUp
as well as
Where clause + Restrict data to a subset of records.
A
adsl
krharrison said:This worked beautifully ! ! ! Many thanks ! !
fredg said:How do you display the results in a textbox from a query in an exit
event of
a previous textbox?
Use a DLookUp.
If the query returns just one record:
[ControlName]=DLookUp("[FieldName]","QueryName")
If the query returns more than one record....
If [Somefield] is a Number datatype, use:
[ControlName]=DLookUp("[FieldName]","QueryName","[SomeField] = " &
SomeNumberCriteria)
If [SomeField] is Text datatype use:
[ControlName]=DLookUp("[FieldName]","QueryName","[SomeField] ='" &
SomeTextCriteria & "'")
In VBA help, look up DLookUp
as well as
Where clause + Restrict data to a subset of records.
A
adsl
krharrison said:This worked beautifully ! ! ! Many thanks ! !
fredg said:How do you display the results in a textbox from a query in an exit
event of
a previous textbox?
Use a DLookUp.
If the query returns just one record:
[ControlName]=DLookUp("[FieldName]","QueryName")
If the query returns more than one record....
If [Somefield] is a Number datatype, use:
[ControlName]=DLookUp("[FieldName]","QueryName","[SomeField] = " &
SomeNumberCriteria)
If [SomeField] is Text datatype use:
[ControlName]=DLookUp("[FieldName]","QueryName","[SomeField] ='" &
SomeTextCriteria & "'")
In VBA help, look up DLookUp
as well as
Where clause + Restrict data to a subset of records.
A
adsl
fredg said:How do you display the results in a textbox from a query in an exit event
of
a previous textbox?
Use a DLookUp.
If the query returns just one record:
[ControlName]=DLookUp("[FieldName]","QueryName")
If the query returns more than one record....
If [Somefield] is a Number datatype, use:
[ControlName]=DLookUp("[FieldName]","QueryName","[SomeField] = " &
SomeNumberCriteria)
If [SomeField] is Text datatype use:
[ControlName]=DLookUp("[FieldName]","QueryName","[SomeField] ='" &
SomeTextCriteria & "'")
In VBA help, look up DLookUp
as well as
Where clause + Restrict data to a subset of records.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.