Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text box shows a result of a query

Status
Not open for further replies.

oraclejunior

Technical User
Jul 8, 2003
111
GB
How does one setup a text box that shows the result of a query. e.g

Afterupdate update of Regname, Textbox1 needs to show the result of

select campaigntable.budget
from capaigntable
Where campaigntable.campaignID = forms!Updateregisterform!Regname;

Thanks
 
oraclejunior,
[tt]DLookup()[/tt]?

Code:
=Dlookup("budget", "capaigntable", "campaignID='" &  forms!Updateregisterform!Regname & "'")

CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top