Trying to reference a value in a subform with a query

[shabbaranks]

Hi guys,



I've forgotten how to reference a value which is in a subform, Im currently using the QBE and the criteria is tha current value in the subform which I wish to copy (but initially I am just trying to select it). Can someone remind me how to reference a value in a subform from a main form or from the QBE?

Thanks!

[RuralGuy]

THis link should help: http://access.mvps.org/access/forms/frm0031.htm

[shabbaranks]

Thanks I was looking at that prior to posting my question, but Im not understanding it hence the post - dont suppose you could elaborate?

As I understand it if I have a record on a subform I should query using (and this would be from the main form)

Me.subformname.form.subformref.value

so the subformname is the name in the property sheet of the form and the subformref is the name of the location holding the data (do you call this a recordset?)

Aplogies for my technique of referencing as I say this is the part which I need to brush up on. Thanks again

[RuralGuy]

Are you going to use a Query or simply reference the SubForm from the MainForm?

[shabbaranks]

Actually Ive just thought, potentially the value within the subform could have multiple different values. What Im trying to achieve is emulate a copy and paste situation whereby a user would click a button and that would copy the last record in a subform into a new record within that same subform - any ideas?

[RuralGuy]

Sorry, none at all.