Results 1 to 6 of 6
  1. #1
    robin
    Guest

    Absolute beginner

    Hi everyone,
    I know this is probably an easy question but for an absolute beginner it's hard to get around, especially if
    the help files don't work.

    I have a form that accepts user input, one of the controls is a combo box who's row source contains values from a
    select operation on a different table.
    All of the controls are bound to another table so that the data written to them will be stored there. I need it to populate the rest of the form (and so update the table) based on a select query from the values of the original combo box. Am I making any sense?
    I know it's a really fundamental problem but I'd appreciate
    any help. Thanks.
    Rob

  2. #2
    Lounger
    Join Date
    Apr 2001
    Location
    KY USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Absolute beginner

    Let me see if I understand: (My example) You have a form for "Sales". This form has a combo box for "Item", which will select a list of items that can be sold. When you select "Snow Shovel", then it populates the form with the snow shovel information. Is my understanding correct? If so I may be able to help you.

  3. #3
    robin
    Guest

    Re: Absolute beginner

    That's exactly right. The value from the combo box hopefully should cause related values to populate other controls on the form, each of which are bound to a table where these values will be stored.
    Thanks for any help.
    robin

  4. #4
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Absolute beginner

    Why do you want to store the same information in more than one place in the database? This could create real headaches for you down the road.

  5. #5
    Star Lounger
    Join Date
    May 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Absolute beginner

    It sounds like you are trying to use the combo box to search for items in the main table. If so then the combo box should be unbound, which means that the result of selecting an item from the combo box does not store a value anywhere. To do this the combo box should not have anything in the Control Source property and in design view the combo box will have "unbound" written in it. Probably the easiest way to make this combo box is to use the wizard to create it for you. If you want to do it manually then you will have to create an event procedure that will search for the record you are after when the combo box is updated ie you will need to create an event procedure for the After Update event of the combo box.

  6. #6
    robin
    Guest

    Re: Absolute beginner

    well the idea is to have one table to store client info that won't change much - client address details etc.
    In the other(s) store info on past transactions with these clients.
    Hopefully a one to many relationship(s).

    Eg. If there is a problem with a delivery, paperwork must be typed up and stored in the database as a kind of online archive - no paper involved.
    What I'm trying to do is to place a combo box on the form
    for incorrect deliveries(for example)that once a purchase order number is selected will fill up the details of that past transaction. The user will then fill up any other details required and archive it.
    Am I making any sense? I'm probably not being very clear about all this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •