Results 1 to 6 of 6
  1. #1
    eldarbs is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    17

    how can I creat a button that add a new rows of controls in a form

    I have an example for a form that I want to create , i'ts a order products
    form's
    I want to create a button that every time I
    clicked on it, it wiill add/create a lines of controls in the form like I
    showed in the example I brought up
    Attached Thumbnails Attached Thumbnails Form_prd.jpg  
    Attached Files Attached Files
    Last edited by eldarbs; 09-08-2012 at 05:22 AM.

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Can't look at the sample right now, but normally you would use a subform for order details, and the new record would appear automatically.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    eldarbs is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    17
    Yes I know about that option, but I want it to look more beautiful and better organized than in table view..
    and in that way you can also add as many items tou need for the order an if i will
    put let's say ten rows it will limmit it for ten items...
    The question is' there is a code that allows to add the controls to a new line on the form and select the items from the order each time you want to add new item ?

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    I would use continuous view rather than datasheet, which I don't like the look of either. I suppose you could hide the line for new records, but it sounds like you want something unbound. That would be possible, but a fair amount of work.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    eldarbs is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    17
    i got your advice and i used the continuous view and i'm o.k. whith that.
    thanks..

  6. #6
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Happy to help.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 1
    Last Post: 03-27-2012, 12:23 AM
  2. Replies: 0
    Last Post: 11-22-2011, 09:22 PM
  3. Replies: 10
    Last Post: 12-31-2010, 12:35 PM
  4. how to creat purchase order
    By arctushar@yahoo.com in forum Access
    Replies: 5
    Last Post: 10-07-2010, 08:14 PM
  5. Replies: 7
    Last Post: 09-22-2010, 02:32 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