Results 1 to 3 of 3
  1. #1
    Brainiac is offline Novice
    Windows 10 Office 365
    Join Date
    Feb 2021
    Posts
    1

    Table lookup + forms

    Hello,

    Please help me with something.


    I have a few tables in my database; some of the fields in those tables are connected to another table through Lookup Wzard.
    The I have some forms based on those tables.
    I wolud like to show in form next to box where I choose something through lookup wizard all the adjacent values of the choosen product.

    For example:
    I pick article 1 in the combobox (defined automatically based on a table with lookup data) adn want to see next to that box all the paramters of Article 1 from the table of articles (price, unit of measure, notes)

    Can you help me to design this.

    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you can use a continuous form of all records, enter the search term in the unbound FIND box (in the header ) and only those records will filter.
    set the afterupdate event:

    Code:
    sub txtFind_Afterupdate()
    If IsNull(txtFind) Then
       Me.FilterOn = False
    Else
          'fuzzy search
       Me.Filter = "[ItemName] like '*" & me.txtFind & "*'"
    
         'exact search
       'Me.Filter = "[ItemName] = '" & me.txtFind & "'"
    
       Me.FilterOn = True
    End If
    end sub

  3. #3
    ssanfu is offline Master of Nothing
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Welcome to the forum...


    Be aware that most, if not all, experienced developers do not recommend using look up FIELDS (different than look up tables).
    See
    The Ten Commandments of Access
    The Evils of Lookup Fields in Tables


    You should only use forms to add/edit data. Users should never interact directly with a table or query.

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

Similar Threads

  1. Replies: 9
    Last Post: 10-10-2019, 05:13 PM
  2. Replies: 3
    Last Post: 06-15-2019, 08:51 AM
  3. Replies: 3
    Last Post: 06-02-2017, 03:49 PM
  4. Creating Lookup Forms From Field
    By mveda2004 in forum Forms
    Replies: 1
    Last Post: 05-08-2013, 09:20 AM
  5. Entering data in forms with lookup tables
    By gretsch in forum Forms
    Replies: 1
    Last Post: 11-16-2010, 11:44 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