extract data from query and fill in form

[Dawnit]

Hi! I have a query field that is an expression, and I would like a text box in my form to fill with the info created with the query expression. Is this possible by using an expression in the text box Source control properties, or any other simple way?

Thanks!

 

[LonnieJohnson]

Sure. If the query that has the expression is the record source to your form, then go to the Field List and drag it to your form. ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[Dawnit]

What if it isn't the record source?

 

[LonnieJohnson]

I'm sorry, let's back up. What type of expression is it? How is the query you are talking about related to the form? ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[Dawnit]

Hi Lonnie, I have posted more detail on my problem here: thread702-83173 you mind checking it out? I'm desperate for a solution, or could I send you the database?

Thank you so much!

 

[LonnieJohnson]

Go ahead and email me. ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[Dawnit]

Thanks Lonnie, I just sent it. You're great for doing this!