Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    1

    Auto filling form fields

    It may be very simple, but I want to have certain fields in my form auto fill with field values from other fields from the same table. Lets say I have a part number and a description, if I select a part number from a drop down menu (combo box), how do I make sure that the corrisponding description pops up automatically in the form field I created for it. In general I'm not getting how to get corrisponding fields to populate the form. Am I making any sense?

  2. #2
    Lghtning4u is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2007
    Posts
    3
    I use
    Private Sub ProductID_AfterUpdate()
    Me.UnitPrice = Me.ProductID.Column(2)
    End Sub

    to add the unit price when selecting a part, but can't seem to get it to work for more than one box.

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

Similar Threads

  1. form not displaying fields
    By ashiers in forum Forms
    Replies: 0
    Last Post: 09-19-2008, 07:02 AM
  2. Auto populate fields on a form
    By ldarley in forum Forms
    Replies: 0
    Last Post: 08-14-2008, 09:39 AM
  3. Auto Scroll in a Form
    By delliott777 in forum Forms
    Replies: 0
    Last Post: 05-31-2008, 07:02 AM
  4. Reports- Auto Expanding Fields
    By mojo53777 in forum Forms
    Replies: 1
    Last Post: 01-10-2008, 05:53 PM
  5. Auto-increment for non-100% numerical fields
    By supernoob in forum Access
    Replies: 0
    Last Post: 05-03-2007, 09:44 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