Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    What you describe is called cascading (or dependent) comboboxes. This requires VBA behind a form. Won't work with table. I NEVER build lookups in table, just comboboxes on form. This is a very common topic.

    So, with my table design, UnitID combobox on form would have a RowSource like: SELECT OrgUnitID, OfficeName FROM OrganizationUnits WHERE LevelID = [cbxLevelID];

    VBA in event procedure(s) would requery the combobox: Me.cbxOrgUnit.Requery

    Some prefer to set RowSource property SQL statement instead of just requerying combobox.

    The trick is figuring out what event(s) to put code into - usually form Current and combobox AfterUpdate and/or GotFocus.



    Unfortunately, this will probably mean a field in Employees for LevelID. Alternatively, use form/subform arrangement. Main form bound to OrganizationUnits and subform bound to Employees. Master/Parent Links set to the associated OrgUnitID and UnitID fields. UnitID will automatically populate with OrgUnitID value when creating employee record.

    Be aware cascading combobox with lookup alias doesn't work nice with continuous or datasheet form.

    You already have a 'picture' of suggested design in my previous post. And it looks like from your other thread you have adopted that structure. Consider this thread resolved.
    Last edited by June7; 07-17-2019 at 02:07 AM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  2. #17
    skydivetom is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    1,038

    Challenging report

    June 7:

    Based on the redesign of the db, I'm now struggling w/ creating a report that mimics the one of the one version. Pls see more details in the following thread:

    https://www.accessforums.net/showthr...954#post434954

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

Similar Threads

  1. Need help with organization Newbie
    By dan@goditmaderanch.com in forum Access
    Replies: 5
    Last Post: 12-05-2016, 11:58 AM
  2. Selections based off of tiered criteria
    By New_2_Access in forum Access
    Replies: 7
    Last Post: 06-19-2012, 11:00 PM
  3. Auto Organization?
    By ProjectCamaro in forum Database Design
    Replies: 9
    Last Post: 01-18-2012, 07:00 PM
  4. Report organization
    By kstyles in forum Reports
    Replies: 7
    Last Post: 01-10-2011, 02:47 PM
  5. Organization help needed
    By Logan in forum Database Design
    Replies: 2
    Last Post: 07-30-2010, 11:00 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