Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Burgas, Bulgaria
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fill in the control in a form (Access 2000)

    I have a continous form where the first control is orderid.It is based on a query.I want however to add other orders.I can do it, if choose another product from the combo box and write down manually the same order number as the previous ones.Can i do it by a code?
    For example the first line in my form reads
    orderid product cartons
    5791 Third Product 1
    If i choose First Product from the combo box, the control OrderID remains blank.I have to write down the number 1 and then Access accepts my edit.And i want with each after update event of the combo box the orderid to be automatically filled in.
    Can somebody help me ? I apply the example in the attachment.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fill in the control in a form (Access 2000)

    Why don't you use a form-subform set-up. In the form, you could use the Orders as your record source then set up a sub-form with the order details linked via the OrderID. That way you can see the complete Order and see the order details below. Then when you add details to an order, the Order ID will populate automatically.

  3. #3
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Burgas, Bulgaria
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fill in the control in a form (Access 2000)

    Thank you very much.It solved my problem.The orderid does populate automatically

Posting Permissions

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