Results 1 to 2 of 2
  1. #1
    idanol.andrian is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    4

    Textbox value to table data


    Can anyone help me please. I have a form with texboxes unbound.I have textboxes Locstatus and locdate. I wanted the value from this textboxes to be the value to a table with locationstatus and location date.this because I want to enter data say for example persons with the same locstats and locdate.I dont want that data entered repeatedly.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    if the form IS bound to the table, (and your Locstatus and locdate is NOT)
    User can enter values into these , then as they enter data in the rest of the form and move to a new record ( ON CURRENT event)
    post the textbox values into the bound fields:

    Code:
    sub form_OnCurrent()
       txtLocStat =  Locstatus 
       txtLocDat = locdate
    end sub

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

Similar Threads

  1. Replies: 25
    Last Post: 08-01-2012, 05:22 PM
  2. Save data from textbox to table
    By GrayWolf in forum Access
    Replies: 7
    Last Post: 03-27-2012, 09:21 AM
  3. Replies: 4
    Last Post: 12-22-2011, 03:04 AM
  4. Replies: 4
    Last Post: 01-05-2011, 07:56 AM
  5. Writing data from textbox to table
    By mll in forum Forms
    Replies: 4
    Last Post: 03-10-2010, 05:10 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