Populate subform based upon a query from listbox

[John Petty]

I have a listbox that has it's masterfield and child field set to one query,
and my subform set to another (while both queries are linked to the same
table)

Once I select an item in the listbox, how can I get it to populate the
subform fields
for another iteration of the main table data?

I hope this makes sense.

Thanks,

John Petty

 

[John Petty]

Allow me to reword and expand a bit.

I have a Master form that houses two tab controls and a series of command
buttons. One tab control holds a login screen and a listbox. The other tab
controls holds a series of subforms that are used for data entry.

I have the listbox initially linked to two of the subforms (depend on which
is active).
and underneath the listbox, I have three command buttons (New Project, New
Iteration and Edit Project).

Depending on the subform, the list box lists all active projects within the
subform's scope.

When I click on the New Iteration command button, I am manually setting the
Master/Child link fields to a Master table that shows all projects available
for new Iterations.

The problem is that when I select an item from the listbox, I need it to
partially populate the active subform, so that the initial data is set and
the user only needs to enter in the new iteration data (i.e. iteration
number, dates, Project status, engineer, etc).

How can I set the the code to allow the active subform to populate?

Thanks,

John