Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    gprzytula is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2022
    Posts
    16
    small progress
    when the called form is not open : the value is correctly transferred and new form is being opened - but on top of my dialogs and I have to close it to return to caller form
    if the called form is already open from menu, the focus is given to that form - but value is not transferred and I can navigate between forms/tabs
    is there an option on open form to open it as a regular tab as in second screenshot . I specified the assignment of field in on load/on open but still with previous open no data transfer

    Click image for larger version. 

Name:	2022-05-25_17h30_22.jpg 
Views:	7 
Size:	85.7 KB 
ID:	47898



    Click image for larger version. 

Name:	2022-05-25_17h35_03.png 
Views:	8 
Size:	33.8 KB 
ID:	47899

  2. #17
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    If the form is already open (not sure that was ever mentioned ) then I doubt the OpenArgs is going to work? The clue is in the name?
    So if the form is already open, then you just set the control value with normal form naming convention Forms!FormName!ControlName ?

    May as well just open the form and they set as above. That way it should work if the form is open or not?
    You would needt to test that though.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #18
    gprzytula is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2022
    Posts
    16
    finally resolved the problem

    specified in on open : transfer of data and open form (that is closed)
    specified in on activate : transfer of data on form already open

    If Not OpenArgs = "" Then
    [Forms]![Bewegingen_open]![Boekref_open] = OpenArgs
    End If

    specified acwindownormal for acwindowmode opens the form as a regular tab and navigation between tabs is possible

    ref = [Forms]![Beweging_Uit]![Boek_ref]
    DoCmd.OpenForm "Bewegingen_open", , , , , acWindowNormal, ref

    Many thanks to all for all help/hints
    best regards, Guy

  4. #19
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    Maybe use TempVars if you want to read or set a value regardless of whether or not the form is open? If using tabbed views that will have to be the default, so remove whatever popup and/or modal properties you have set. If you want to open it some other way at times then set the window data mode or form popup/modal property in the opening code. AFAIK, those will override the tab view.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #20
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    That syntax is for setting an external form control?
    As I mentioned before, if that is the form, use Me., and then it is much clearer to anyone viewing the code
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 03-09-2018, 10:18 AM
  2. Replies: 6
    Last Post: 07-28-2017, 01:36 AM
  3. Replies: 24
    Last Post: 03-27-2017, 09:24 AM
  4. Replies: 2
    Last Post: 05-29-2013, 01:44 PM
  5. Replies: 2
    Last Post: 03-10-2013, 01:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums