Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 65
  • Last Modified:

ms/acceee link a subform to a control

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
João serras-pereira
Asked:
João serras-pereira
  • 5
  • 3
2 Solutions
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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
 
João serras-pereiraAuthor Commented:
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
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Gustav BrockCIOCommented:
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
 
João serras-pereiraAuthor Commented:
a big THANKS!!!!!
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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
 
João serras-pereiraAuthor Commented:
thanks!!
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now