Converting a list box to a datasheet

[Guest]

Hi,

I have a list box that I use to display the results of a query - the query
is dynamically generated using SQL statements which I then use for the
RowSource property of the listbox. Everything works fine.

I figured now it would be better to use a datasheet form to display the
results - this would be enbedded within my "Search" form.

Anyone know how to do this?? The subfor has no RowSource Propery.

 

[Duane Hookom]

A subform has a Record Source property that is similar to a Row Source
property. You can use code to set the SourceObject of your subform control
to the query:

Me.subformctrl.SourceObject = "Query." & strQueryName

There is a sample of this in the DynamSubfrm at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.