Results 1 to 3 of 3
  1. #1
    JamieGMN is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2021
    Location
    Minnesota
    Posts
    1

    Question Data Entry Form that pulls/pre-populates field based on previous data in the table


    I am trying to develop a "new invoice form" that will pull up previous invoices as reference and allow modification. I am using VBA .addnew code to write the new invoice data into the table but am struggling with the best way to pre populate the fields (and thus minimize the need to change data if majority of the bill/field are the same time after time). When I pull previous information via query to the form, any edits actually change the prior data. I really just want to load the values but not have dynamically linked. thanks

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,446
    Maybe this will help
    http://allenbrowne.com/ser-57.html
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,287
    Another technique you might find useful is VBA to set control's DefaultValue property so entered value will carry forward to subsequent records in same session.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 4
    Last Post: 08-30-2017, 07:10 AM
  2. Replies: 9
    Last Post: 03-01-2017, 10:00 AM
  3. Replies: 1
    Last Post: 12-04-2016, 05:43 PM
  4. Replies: 7
    Last Post: 03-05-2015, 07:34 AM
  5. Replies: 3
    Last Post: 02-25-2015, 04:48 PM

Tags for this Thread

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