Selecting data on subforms and make them display on form fields

[rodvaN]

Hello there, is this possible?
I got this query subform with the same fields that appear on the main form, what I want to to is when chosing the row of data in subform, make it display on the main form.
Thanks

 

[SOS]

Can you elaborate on why you are using a subform for this instead of, say, a listbox? Subforms are really meant to display the many side from a one-to-many relationship and be tied to the main form in that you select a record on the main form and the records in the subform show what records are related to that one record, not selecting a record on a subform and displaying something on the main form.

 

[rodvaN]

The subform filters all the data by an order number, while you are navigating by arrows when you reach other order number data, it will filter the data.
I guess this cant be made by listbox right?

 

[SOS]

I'm not understanding your description. Can you post a screenshot (just upload - don't host it on some site as I can't get most of them at work)?

I still think you are using the subform in a way it wasn't intended but I'll reserve judgement until I can see what it is you are actually trying to do.

 

[rodvaN]

Here I post the image.. that form displays the query based subform filtered by the document number, I marked all.
Thanks in advance.

 

[rodvaN]

Forgot to mention I generate a Report via that filtered data.