View Full Version : Query results in a form


John M
11-30-2001, 01:02 AM
Is it possible to return a query result within a "datasheet" within a form. The current default is just a "datasheet" which is quite ugly and cumbersome.

Fizzio
11-30-2001, 02:57 AM
You can set up a form to display the records in a datasheet view. On the form properties, on views allowed, set it to datasheet only and base the controlsource of the form on the query in question. This is often useful on a main form in form view and a subform in datasheet view.

John M
12-06-2001, 04:58 PM
Is there a way in VB to reference the individual cell contents of the datasheet. When I press a button on the main form I want to be able to read the contents of certain cells in the datasheet and then act on it.