Help with append queries and linking subforms

[MelonFuel]

Hi


I have created an Append Query.


the table tblQueue is the field where it keeps the data.


I have made a query from the tblQueue and that is now on the main form as a subform.


The subform isn't linked to anything via master and child.


There is a drop down list on a another subform that i think i need to link the data to.


Heres the code that i've used to run the append query.

Private Sub Append_Click()


stDocName = "qryOrderAp"
Docmd.OpenQuery stDocName, acNormal, acEdit
Me.Refresh


MsgBox "Done!"


End Sub

Any help would be appreciated.


Thanks.

[June7]

What is wrong - error message, wrong results, nothing happens? Show the sql statement of qryOrderAp.

You 'think' you need data from combobox on another subform? How would we know better than you what is needed? We don't know your data structure.