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

2 subforms on mainform

  1. #16
    skydivetom is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    278

    Bob -- your modified version includes some very intriguing processes. I wish we had had this dialogue several months ago when working on the general architecture. I will further review whether or not I can simply plug in your form into the actual database. That is, we have some business rules which may preclude it. For example, in some cases, the users do want to see which members have not bee assigned to a billet (vs. removing their names from the combo).

    However, at the same time, I am very much intrigued by the ability to remove a value (e.g., lastname) from the combo once that value has been assigned. I looked at the VBA but I didn't recognize which code or property automatically remove a previously assigned lastname from the values left/shown in the combo.


    Could you please elaborate what function/code is performing that auto-refresh?

    Thanks,
    Tom

  2. #17
    Bob Fitz is online now Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,099
    I am very much intrigued by the ability to remove a value (e.g., lastname) from the combo once that value has been assigned. I looked at the VBA but I didn't recognize which code or property automatically remove a previously assigned lastname from the values left/shown in the combo.
    This is achieved more with the SQL statement used for the combo box than with code. Only code required is to requery the combo box after a selection has been made.

    I felt that was a more intuitive way of doing it. I hope you agree.
    If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
    Not everyone can access an accdb, you may reach a broader audience by attaching in mdb format.

    Bob Fitzpatrick

    I have never failed. I have found a thousand ways that do not work!

    Microsoft Community Contributor Award (2011)



  3. #18
    skydivetom is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    278
    Bob... really smooth way of managing this process. I noticed the very tiny combo box... it made more sense after I further reviewed those properties. Again, very elegant solution! Thank you.

    Cheers,
    Tom

  4. #19
    Bob Fitz is online now Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,099
    Quote Originally Posted by skydivetom View Post
    Bob... really smooth way of managing this process. I noticed the very tiny combo box... it made more sense after I further reviewed those properties. Again, very elegant solution! Thank you.

    Cheers,
    Tom
    Glad you liked it .

    From your post #16:
    ....we have some business rules which may preclude it. For example, in some cases, the users do want to see which members have not bee assigned to a billet (vs. removing their names from the combo).
    But surly that is exactly what happens with the latest version offered?
    If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
    Not everyone can access an accdb, you may reach a broader audience by attaching in mdb format.

    Bob Fitzpatrick

    I have never failed. I have found a thousand ways that do not work!

    Microsoft Community Contributor Award (2011)



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

Similar Threads

  1. Search subform from mainform
    By ittechguy in forum Programming
    Replies: 70
    Last Post: 10-04-2015, 06:08 AM
  2. Link between subform and mainform
    By crowegreg in forum Forms
    Replies: 2
    Last Post: 08-24-2011, 07:05 AM
  3. Replies: 3
    Last Post: 06-20-2011, 09:30 AM
  4. MainForm/SubForm question
    By 10 Gauge in forum Forms
    Replies: 5
    Last Post: 03-04-2011, 07:46 AM
  5. Replies: 0
    Last Post: 03-14-2009, 12:33 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
  •  
Tech Forums: Microsoft Office Forums