Subform gives data to main form

[wlanssens]

Hey!



I'm trying to make a form which gets it information in the textboxes out of a selected row in a subform.
So I have a form say frmMain which has a few textboxes on top and a subform below in table form, if I select a row in the table (subform) the information gets filled in in the textboxes on top.
I haven't found a way to make it work like this.. somebody with an idea?

Thanks!
W.

[ItsMe]

In the subform's class module you can reference the main form's controls like this

Forms!frmMainName![ControlName].value = Me.SomeControl

[orange]

But a typical form/subform setup uses 2 tables. The tables are typically related in a 1 to Many relationship. The 1 side is in the Form and the many side is in the subform. For a given identifier in the 1 table (Mainform), the related records in the many table are displayed on the subform.

[June7]

You should give the subform container control a name different from the object it holds, like ctrDetails.

Then, if you want a textbox on main form to reference a field/control on subform, the reference should be:

=[ctrDetails].[Form]![fieldname]

=[ctrDetails].[Form]![controlname]

(those will give intellisense popup tips that list field and control names)

or simply =[ctrDetails].[fieldname]

But maybe what you really want is a Split form.

[wlanssens]

I'll explain a bit more.. I have a table with workorders, with the columns workorder number, description, ...
I have a second table with more in depth info on a specific workorder, like who is going to work on that order etc.. a one-to-many relationship.

I want to have a form where I can see the table with different workorders, and if I select a specific workorder (row) in that table I can see more details (out of the second table) above that subform..
Does it require VBA? Not that I won't manage but its been a while :-)

thanks for the reply's!
W.

[orange]

I would try

Form1 <-----recordsource tblWORKOrders  This is the 1 table
     subForm<------recordsource tblWorkOrderDetailedDescriptions   THis is the many table

The linkfields would be WorkOrderId

[June7]

Yes, some amount of code needed if you want to go beyond the intrinsic Access search/filter tools.

Options:

1. Follow orange's guidance and build a form/subform. Main form bound to Workorders and subform bound to WorkorderDetails. Have an unbound combobox on main form that lists workorder numbers or customer that can be used to enter search criteria to either filter the Workorder dataset or go to record.

2. synchronize two subforms, one bound to Workorder and one bound to WorkorderDetails: https://www.fmsinc.com/MicrosoftAcce...edSubforms.asp

3. open a 'popup' form of the details

[wlanssens]

Okay, I'll give these options a try and see which one fits best :-)
Thanks for the assistance!

[June7]

Probably should ignore option 3 - I didn't think that one out well.