Subform Question

[smsmail]

Hi All,

From what I have read, subforms are ONLY for one-to-many relationships (i.e. parent/child), not for listing all the records of a table that meet the user's selection criteria.

Can I use the subform object that VBA supplies, to list records based on the user's selection criteria?

What I am trying to do is allow the user to view a list (similar to that of a subform) of all the records of the table that meet the user's selection criteria.

Can I do this with a subform object or will I have to create a form to do this?

I hope this does not sound too confusing -

Thank you in advance for your help!!!

 

[dhookom]

I assume this is an Access question and should be asked in the Access Forms forum.

However, there is nothing that suggests subforms are only for displaying records relating to a main form. You can display any set of records.

If you have a follow-up questions, please create a new thread in forum702.

Duane
Hook'D on Access
MS Access MVP