Results 1 to 4 of 4
  1. #1
    Jeremy Sng is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Aug 2016
    Posts
    43

    Produce the number that belong to the work number

    I got a problem to display the number that is belong to the work number on my part list.



    Example:
    When my work number is 1 i will only show work number 1 part list. But i got the issue is when i want to enter work number 2, work number 1 part list still show on the form. What show i key in the query criteria?

    I did relationship with part list and work done but still got the problem.

    I need help. Try one whole day i still cant solve the problem.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in a query, join tParts to tWork tables on the Work# field.
    this query can read from a form (text box or combo box)
    set the query criteria using the form obj:

    forms!myForm!cboWorkNum

  3. #3
    Jeremy Sng is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Aug 2016
    Posts
    43
    Hi Ranman,

    The program doesn't work. It will still shown workno 1 changeout 1 in the part list.

  4. #4
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Did you requery the form after changing the key? "Me.Requery"

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

Similar Threads

  1. Replies: 2
    Last Post: 10-12-2016, 05:48 PM
  2. Replies: 7
    Last Post: 02-27-2015, 09:21 AM
  3. Replies: 5
    Last Post: 11-30-2014, 12:46 PM
  4. Replies: 6
    Last Post: 01-24-2013, 10:02 PM
  5. Replies: 6
    Last Post: 07-25-2011, 01:54 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