Reading Data in a Subform with VBA

  • Thread starter =?ISO-8859-1?Q?=22Eoin_C=2E_Bair=E9ad=22?=
  • Start date
?

=?ISO-8859-1?Q?=22Eoin_C=2E_Bair=E9ad=22?=

Hi

In a VBA module, my way of reading data in a subform is to read the main
look-up key from the main form, and then run a query to get the records
that appear in the sub-form, rather than reading the subform directly.

Is there a way of reading the sub-form directly ?

Thanks

Eoin Bairéad
Dublin, Ireland
 
K

Ken Snell [MVP]

You could cycle through the subform's recordsetclone and read the records
that way. Provide more information about what you want to do with the data
from the subform's records and your form/subform setup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top