Re: Populate a subform using VBA

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

XP wrote:

Using Office 2003 and Windows XP;

Is there a way to populate a subform using the results of a recordset using
VBA?

If so, could someone please post a generic VBA example?


That's a pretty generic question, so I guess a generic
answer is about all I can provide ;--)

Set Me.subformcontrol.Recordset = rs

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Help!!!! #Name? Error
    ... I trying to populate a subform from a recordset created on ... Dim rsData As New ADODB.Recordset ...
    (microsoft.public.access.formscoding)
  • Re: Populating unbound forms
    ... Dean, if you want to fool with what Peter Walker calls "novel ideas", you can create an ADO recordset on the fly, and bind it to the Recordset of your form: ... Since subforms are designed to show relational data, every time you move record in the main form, the subform repopulates with the matching records, so a Recordset is not helpful. ... There is not many article on unbound forms maybe thats because unbound forms ... > Hi how do i populate a unbound form. ...
    (microsoft.public.access.forms)
  • Re: Populate a subform using VBA
    ... Since a subform's open event occurs before the main form's ... I don't see how it can say the form object is not ... I even trashed and rebuilt the subform, ... could someone please post a generic VBA example? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Subform email
    ... You have to loop through the subform's recordset and send 1 email at a time. ... make it populate the email of the resource in all the records on the ... subform. ... items on subform are Tasks assigned to a Resource with a DueDate. ...
    (microsoft.public.access.formscoding)