Page 4 of 4 FirstFirst 1234
Results 46 to 58 of 58
  1. #46
    KCC47 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    77
    Here it is.

    Thank you
    Attached Files Attached Files

  2. #47
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Set combobox ColumnHeads property to No.

    There is no data in Applicant_Tbl. So anything you type into the Applicants combobox will trigger the NotInList error. Put data into table. Same goes for the VIN combobox.

    If you want to add VIN and Applicant records 'on-the-fly' then use the NotInList event to accomplish that http://support.microsoft.com/kb/197526.

    Should the Rejection_Reason_ID combobox LimtToList property be Yes?
    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. #48
    KCC47 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    77
    Can I just use the code from post# 26?

    I would put the first part in the Applicant_ID_ComboBox of the Applicant_Junction_SubFrm, and the second part in the Applicant_Add_Frm?

  4. #49
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Wow, forgot already discussed code for NotInList event.

    Yes, could apply the same concept, just modify code appropriately.
    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.

  5. #50
    KCC47 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    77
    I'm getting closer, but now a new error is showing:

    Option Compare Database
    Private Sub Form_Current()
    If IsNull(Me.ID) Then Me.ID = Me.OpenArgs
    End Sub

    It debugs after it asks the question "Do you want to add this applicant?" the underlined section is highlighted? This is in the Applicant_Add_Frm

  6. #51
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Can't pass ID because that is an Autonumber field. It is not the ID that should be passed it is other data, like name.

    Also, just realized trying to pass a name to the Applicant_Add_Frm is too complicated. Did you and I already have that discussion or was that another poster?
    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.

  7. #52
    KCC47 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    77
    No it was me. So should I just forget putting the onload event procedure on the Applicant_Add_Frm?

  8. #53
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Yes, I seem to remember that was the determination.
    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.

  9. #54
    KCC47 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    77
    Wonderful, that appears to be working.

    Is there a way to search for records in the Applicant_Tbl on the master form? I get an error message if I attempt to search in the subform control?

  10. #55
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Bound controls cannot be used to input search criteria. Also, a subform cannot control the main form (children do not command parent).

    Parameterized query is one way to filter forms and reports. I don't prefer that method but it is easy to do and requires minimal code.

    Review http://datapigtechnologies.com/flash...tomfilter.html
    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.

  11. #56
    KCC47 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    77
    The remainder of my questions relate to a report using this master form. Should I start a new thread in the report section?

  12. #57
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Might be a good idea if the question gets into new territory. Can always include a reference to this thread.
    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.

  13. #58
    KCC47 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    77
    Thank you for your help here June7. I've done just that in the report section. I'm marking this thread answered.

Page 4 of 4 FirstFirst 1234
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 06-20-2012, 12:00 PM
  2. Linking Subforms on Unbound Master Form?
    By 10 Gauge in forum Forms
    Replies: 8
    Last Post: 07-21-2011, 08:06 AM
  3. Replies: 22
    Last Post: 03-15-2011, 07:17 AM
  4. Master/Child between Subforms
    By Pilotwings_64 in forum Forms
    Replies: 3
    Last Post: 08-22-2010, 01:45 AM
  5. Replies: 2
    Last Post: 06-14-2010, 03:25 PM

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