Results 1 to 3 of 3
  1. #1
    jlgray0127 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Location
    Central Illinois
    Posts
    187

    Navigation Form used as SubForm

    Hey all!
    Trying to figure this out, with the navigation subform in 2010.
    I have a main form, with a navigation form, as a subform.



    In my Navigation subform, there are 7 tabs, representing 7 subforms.
    I have a check box in each of the subforms. When I click it, changing the value to true, I want it to update the date value on this form, to the date I have on the main form.

    Writing the vba for it, I can not seem to reference the mainform.

    Any thoughts as to why it does not see recognize the form? I am certain it has something to do with the navigation form, as it's been nothing but a pain in the neck since I put it in place.

  2. #2
    jlgray0127 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Location
    Central Illinois
    Posts
    187
    This is the string.... SysProgramMaint is the main form

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Adjusting a form or its controls' properties that reside within Navigation Control/Form is difficult if not impossible. Consider the properties of the tab/buttons for the Navigation Control. Anything beyond the properties in the property sheet are most likely out of reach.

    One approach may be to use code in the Form's VBA module. I am referring to the form that is the subform within Navigation Control. If you can find an event, there, that fires with the User's actions; that may be the best solution.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 12-19-2013, 12:34 AM
  2. Replies: 4
    Last Post: 10-08-2012, 05:33 PM
  3. Navigation subform Query Criteria
    By RayMilhon in forum Queries
    Replies: 2
    Last Post: 08-10-2012, 01:26 PM
  4. Subform Reference on Navigation Form
    By rts in forum Forms
    Replies: 1
    Last Post: 06-05-2012, 02:05 PM
  5. Navigation Subform issues
    By bsc in forum Programming
    Replies: 1
    Last Post: 11-29-2011, 11:37 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