Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19

Hit a wall - Canít get multi table form to work

  1. #16
    Wfoley82 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    7
    June7,

    Missed the link. Got it now.



    I can't find the youtube video now, but he basically had a query below the fields of the subform. In his example the subform was for adding new orders and then below the fields it had a list of all the orders that customer had made.

  2. #17
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,246
    What YouTube?

    Allen Browne example does not involve subform.
    Form allows input of new records as well as search for existing.
    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.

  3. #18
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,057
    G4S PRH Personnel -davegri-v02.zip
    See attached. 2 small changes. Added search combobox to main form.
    Changed the layout to datasheet for the form showing on the certification tab. I assume that's what your second request means.

  4. #19
    Join Date
    Apr 2017
    Posts
    987
    In case you want a design, where the main form is unbound one, and all other forms (employees form included) are continuous subforms on tab control pages, to link other subforms with employees form:
    You have an unbound control on main form. In OnCurrent event of employees form you have a code which writes current employee ID into unbound control in main form. Other subforms which must be linked with employees form, are linked to this unbound control instead (Access will protest, but ignore this!).

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

Similar Threads

  1. Replies: 6
    Last Post: 10-15-2014, 02:24 PM
  2. Replies: 2
    Last Post: 07-15-2014, 10:39 AM
  3. Replies: 2
    Last Post: 05-22-2012, 03:29 PM
  4. Hit Statement & Syntax Wall
    By Soule in forum Programming
    Replies: 5
    Last Post: 01-17-2012, 03:48 PM
  5. Help banging my head against a wall working on this
    By Brian Foshee in forum Programming
    Replies: 1
    Last Post: 06-04-2010, 08:30 AM

Tags for this Thread

Posting Permissions

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