Results 1 to 6 of 6
  1. #1
    ric_c is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    3

    Unhappy Need help adding a new blank data line like a "new line"

    Obviously new to this.

    I have a problem I can't figure out. Here's the situation:

    I have data in a form for a POS I'm working on. It would be the UPC, description, price for example. I need a way to make a new blank line that can be filled in with the next UPC, description and price when the previous one is filled in.

    Like this:

    Retail form is opened.

    Existing Customer information is search and filled in from the customer form.



    The first blank data line is there ready to read the UPC, search and fill in the associated data from the stock form.

    When for example return is pressed a new blank data line is inserted ready for the next UPC code.

    This continues until DONE is pressed.

    I can't find how to add the new line for data. I've been stumped for too long and all of my searching online hasn't help.

    Thanks in advance for any suggestions.

    Ric

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    It sounds like you need your data on a continuous form probably as a subform. Then way you can add as many records (new lines) as you like and have static data at the top on the parent record.

  3. #3
    ric_c is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    3
    Ok, but how would you do the actual add of the new line?

  4. #4
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    It depends if you really want to ues the enter key.

    If you get to the last field in the tab order of the subform then press Tab you should be taken to a new line.

  5. #5
    ric_c is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    3
    forgive my stupidity, so after tabbing through and getting the new line it would be ready for the next UPC code and automatically fill in the rest of the data based on that UPC once it's entered?

  6. #6
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    ...automatically fill in the rest of the data based on that UPC once it's entered
    This is possible but won't happen on it's own. You will have to program the auto-fill part.

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

Similar Threads

  1. Setting Blank Fields to "N/A"
    By AKQTS in forum Reports
    Replies: 6
    Last Post: 07-15-2011, 04:40 AM
  2. Replies: 4
    Last Post: 12-03-2010, 04:05 PM
  3. Replies: 2
    Last Post: 02-04-2010, 10:45 AM
  4. Replies: 1
    Last Post: 10-19-2009, 02:37 AM
  5. Replies: 1
    Last Post: 09-05-2008, 12:07 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