Text box to show specific record

[chu3w]

Hi, Can I make the text box on a form to show data from a specific record? For example, I have a table with two fields Quarter and Revenue. Can I make the text box to show just the data for revenue in Quarter3?

 

[vbaInet]

Use a DLookup() in the Control Source of the text box. Check the help files on how to use this function and also see this link:

http://www.blueclaw-db.com/domain_aggregate_function/dlookup-function.htm

 

[Isaac]

Can't you just use a Bound form, with the form's Recordsource be the query with the two columns you want to show and bind the control to the appropriate recordsource field?