none
How to refer to a form in a navigation form object RRS feed

  • General discussion

  • Hi,

    Considering a main form (frmMainNav) with theses different components: 

    A navigation form object (navMainInvoice) with 3 pages, but we'll  focus on page 1 whose:

    Navigation Target Name property =  frmMain in which there are 2 subforms in frmMain detail area

    1. frmMainInvoice
    2. frmMainInvoiceDetail which is the frmMainInvoice detail record  (remember it's not a frmMainInvoice subform)

    And when I change value on  frmMainInvoiceDetail record field,  I need to assign  dynamically to  frmMainInvoice value fileds the aggregates  amount of each detail items

    So how to access on frmMainInvoice recordsetClone ?  As follows

    Forms("frmMainNav").Controls("navMainInvoice").Form("frmMainInvoice").Form.RecordsetClone

    It's very tricky because as may be seen, we never refer to frmMain but directly to its sub forms. Why, I can't give you a precise explanation !












    Saturday, June 11, 2016 6:54 PM

All replies

  • I give you the solution here  . 














    Saturday, June 11, 2016 1:22 PM
  • Hi. The syntax basically goes like this:

    Forms!FormName.SubformControlName.Form!ControlOnTheSubform

    If it's a subform within a subform, it might go like this:

    Forms!FormName.SubformControlName.Form!SubformControlName.Form!ControlName

    Just make sure you're using the name of the control rather than the form. For example, in a navigation form, the subform control might actually be called "Navigation Subform."

    Hope it helps...

    Saturday, June 11, 2016 4:27 PM
  • Hi. Is this related to this other question? https://social.msdn.microsoft.com/Forums/en-US/a8096bcc-3911-4a89-aa1e-94902d60cfc2/how-to-refer-to-field-in-a-form-inside-a-navigation-form-from-a-another-form-in-the-same-page?forum=accessdev
    Sunday, June 12, 2016 4:29 AM
  • You are right and ow to proceed to remove it?
    • Edited by technet65 Sunday, June 12, 2016 7:24 AM
    Sunday, June 12, 2016 7:23 AM
  • Hi TechNet,

    If you find a solution, you do not need to change the thread type from question to discussion, you could share us your solution with a new reply under your question, and mark it as answer. Then others who run into the same issue would find the solution easily.

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Monday, June 13, 2016 7:44 AM
  • Hi technet65,

    I agree with the suggestion given by the Edward.

    you have shared a link but there is no solution only the thing is that you had post 2 same question in different forum. so our Moderator had merged that 2 into 1 to avoid duplication.

    now I would recommend you to post your answer in new reply and mark it as an Answer.

    if you are seeking more response related to your issue then I would recommend you to please check the suggestion given by  .theDBguy.

    if you still having a problem related to your issue then please let us know so that we can provide you further help.

    Regards

    Deepak 


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, June 14, 2016 2:46 AM
    Moderator