Solved

ms/acceee link a subform to a control

Posted on 2016-11-12
9
39 Views
Last Modified: 2016-11-13
Hi.
I am developing a form that contains 2 subforms. The first subform contains a  list of records that, when a make a specific record "current", by clicking on it, I want to see all details on the right subform that is a single form, not a list.
the master form for both, contains a control that is updated every time I make a new record current on the list form and it works perfectly.

However, this masterform control is "unbound" to a Table/Query as I just want to select a specific record to show the detail, and do not want to change the content of the record itself.

is there a manner to link a subform field to this control?
alternatively:
if I bind the control to the table/query, is there a manner to make the "current" record in the list subform, a current record on the master form, so the master/child relation can work for the other form?

thanks in advance
(I am embedding a screenshot of the form where you may see the master form with a now visible and correct key, and both e list subform (on the left) and the single subform (on the right)

thanks in advance




screenshot
0
Comment
Question by:jirdeaid
  • 5
  • 3
9 Comments
 
LVL 19

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 500 total points
ID: 41884600
you can use a reference to the control in subform1 for the LinkMasterFields of subform2:
     subform_controlname1.form.controlname

Open in new window

Alternately, you can use the unbound control you are updating.

On the current event of subform1:
     me.parent.subform_controlname2.requery 

Open in new window

0
 

Author Comment

by:jirdeaid
ID: 41884663
Hi
now I am scratching my head...

the unbound control name is [fld_codigoTicket] but I can't figure ou a manner to link this to the subform... In the menu is just allows me to link IF the field is bound...

please check the screenshots

ss1
ss1
ss3
0
 
LVL 19

Assisted Solution

by:crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access earned 500 total points
ID: 41884670
type the control name you want in LinkMasterFields without using the menu

LinkMasterFields can be an unbound control.  It can also, as I showed above, reference the control on the first subform.  Just type what you want ;)

You must, however, requery subform2 in the Current event of subform1 so it changes right away
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 49

Expert Comment

by:Gustav Brock
ID: 41884676
This is automatic.

On the main form:
Form unbound.
fld_codigoTicket is unbound (as now)

On the left subform:
Have this code in the OnCurrent event:

    Me.Parent!fld_codigoTicket.Value = Me!codigoTicket.Value

Set Master/Child link fields to left subform:
Empty.

Set Master/Child link fields to right subform:

    MasterLink: fld_codigoTicket
    ChildLink: codigoTicket

/gustav
0
 

Author Closing Comment

by:jirdeaid
ID: 41884680
a big THANKS!!!!!
0
 
LVL 19
ID: 41884681
you're welcome ~ happy to help
0
 
LVL 19
ID: 41885388
after looking up one of my past projects, I see that all I did was use an unbound textbox on the mainform for LinkMasterFields of the second subform with this equation:
    =nz(subform_controlname1.form.controlname)

Open in new window

No requery is needed in code behind the first subform -- Access does everything automatically

Unlike LinkChildFields, which must be a field(s) in the RecordSource and better to be in a control(s) on the subform (Visible can be No), LinkMasterFields can be an unbound control(s).
0
 

Author Comment

by:jirdeaid
ID: 41885408
thanks!!
0
 
LVL 19
ID: 41885423
you're welcome ~
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now