Results 1 to 3 of 3
  1. #1
    Micka is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2017
    Posts
    2

    How to keep the same client on multiple sales after pressing the new sale button.

    I have created a simple invoice screen to use to sell drinks when we go to different events. So I would like to have the same client for that day without having to enter it each time.



    Thanks

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,933
    something like this in the form beforeupdate event

    clientID.DefaultValue = Nz(clientID)

    where clientID is the name of the control on the form which the user selects a client

    if clientID is text, then it would be

    clientID.DefaultValue = """" & Nz(clientID) & """"

    Edit: you will probably then want to lock the control so users cannot change it in which case in the same event add the code

    clientID.Locked=true

    To unlock, close and reopen the form

  3. #3
    Micka is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2017
    Posts
    2
    Thanks Ajax, I will give it a go.

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

Similar Threads

  1. Replies: 6
    Last Post: 11-19-2017, 08:41 PM
  2. Replies: 4
    Last Post: 05-03-2017, 10:37 AM
  3. Replies: 3
    Last Post: 03-11-2015, 03:28 PM
  4. Replies: 4
    Last Post: 10-23-2014, 12:21 PM
  5. client database for insurance sales
    By rublerv in forum Access
    Replies: 1
    Last Post: 03-25-2010, 08:00 AM

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