display data in textboxes/cells

[qwertyjjj]

Is there a way to display data from a query in control boxes instead of in a datasheet view?

 

[finalee]

Hi qwertyjjj.
If you have a suitable Form then you can set it's Record Source to your saved Query (or you can design one and do this).
Would that work?



Legal IT Forums
Free technical forum for Legal IT professionals

http://www.legalitforums.com

 

[randy700]

Open a new form using the query as the record source. On your toolbar, you should have an icon for 'field list'. Click it to display the available fields. When you drag one of the items from this list and drop it on the form, it will create the text box for you.


Randy

 

[jkl0]

Using the form wizard to create a new form choose a Columnar form instead of datasheet.