Search:     Advanced search
Browse by category:
Glossary | Contact Us

Database Knowledge Base / MS Access /

How do I access the recordset of a SUBform. I know how to clone the set of a form, but this doesn't work for subforms.

Add comment
Views: 293
Votes: 3
Comments: 0
All Versions: Let me guess, you tried: forms!myform!MySubForm.RecordsetClone

This will always fail as MySubForm points to a control on the form, you need to access it's Form propery, thus:

forms!myform!MySubForm.Form.RecordsetClone

Should work OK.
Others in this Category
document When compacting an Microsoft Access database how do you control the ownership of the database?
document How can I make my combo and list boxes faster?
document Where can I obtain a list of Access Basic Errors and their associated messages
document How do I emulate the "Record X of Y" that Access displays in the navigation buttons
document How do I run an internal DOS command from within Access Basic, if I try x=Shell("copy file1 file2",1) I get a message "File not found".
document How we can perform MINUS (Oracle) Or EXCEPT (Maxdb) in MS Access?
document What is Data Mapping
document What is an Ad Hoc Query?



RSS