Results 1 to 4 of 4
  1. #1
    grad2009 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    27

    some problems with my program

    hello guys,

    I have done stock program in Microsoft access. I created a table with name Items. That table contains itemNo (the primary key). , itemDesc. , unit , and price attributes. Also I created a table with name Sales which contains sales's invoice No (sInvoiceNo) (the primary key), date, itemNo, quantity and total price attributes. Then I created a form which contains sInvoiceNo, date, itemNo, quantity, total price form Sales table and itemDescription, unit, price from the Item table. So when I enter the itemNo in that form , the related information such as (itemDesc, unit, price ) appears automatically (without user) but by this way it is more difficult for the user to remember all of the items Numbers. I tried to enter the itemDesc instead of itemNo but here the related information such as (itemNo, unit and price) don't appear automatically, it needs to fill by users.
    Now , my question is I want the related information appears automatically when I enter the iemDesc instead of itemNo
    can you help me please and i would be so thankful for you
    I'm looking forward to hearing from you,


    thanks with regards,

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    ItemNo and ItemDesc are two different fields. Each should be a multi-column combo boxes, such that on the AfterUpdate event of the one selected, the combo box columns are used to update your form.

  3. #3
    grad2009 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    27
    Thank you for your fast reply, yes the tow fields should be a multi-column combo boxes but, do you mean then to write some code in the AfterUpdate event to let the related informations appear automatically.

    thanks with regards,


  4. #4
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Yes, that's correct. Don't your combo boxes have several columns - containing the data the be populated on your form?

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

Similar Threads

  1. Program to load data
    By fsmikwen in forum Access
    Replies: 2
    Last Post: 12-10-2009, 08:36 AM
  2. Error 3061 in VBA program
    By fbou in forum Programming
    Replies: 5
    Last Post: 10-07-2009, 11:00 AM
  3. Access chat program
    By cuneyt in forum Programming
    Replies: 1
    Last Post: 09-08-2009, 02:44 PM
  4. Do i need a custom program for this?
    By hokie in forum Programming
    Replies: 9
    Last Post: 07-17-2009, 06:27 AM
  5. Set focus to another program
    By DrewB in forum Programming
    Replies: 1
    Last Post: 06-24-2009, 06:38 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