Subform Source (1 Viewer)

[npierson]

I made a query that displays values based on a combo box (unbound) on a form, but I need to figure out the following since I want to display the queried values on the form then send the query or subform to a client (not important):

How can I make a subform display values from a query? OR How do I display a query on a form?

Thanks,

Nick

[This message has been edited by npierson (edited 06-07-2001).]

 

[charityg]

This seems like a simple answer, so it leads me to believe that you have something more complex in mind, but have you set the subforms datasource equal to the query?

 

[npierson]

I set the record source of the subform equal to the query, yet when I select a value from the combo box nothing happens (and the I'm sure the query works). As you stated, it does seem like an easy question to answer, so I must be missing the obvious.

Thanks,

Nick

 

[charityg]

you need to requery the subform. AfterUpdate of the combobox.
Me!SubfrmName.Requery

 

[npierson]

Charity,

I can't thank you enough for all of the help you've given me in the past few days. I finally works.

Thanks again,

Nick