Results 1 to 3 of 3
  1. #1
    hawzmolly is offline Advanced Beginner
    Windows 7 Access 2010 32bit
    Join Date
    Oct 2008
    Location
    Green Bay, WI
    Posts
    77

    Value in Text Box will not transfer to my table when I close the Form

    I have a table that I am using to create a train manifest for our model railroad clubs operating sessions. I need to print the manifest after creation for the guys to use. I also need to be able to save the manifests for future use.

    Here are the text fields I need to populate in the table: (These are my actual field names)
    ABV, ABV1, ABV2 - These are the "Train Names". ABV is a concatenation of ABV1 and ABV2 i.e., [GNYO1 - AFCJC1]. The train names are derived from a table of all of the possible "Drop" or "Pick-up" locations. Example: GNYO1 = Green Bay North Yard Outbound Track 1.

    See the attached pictures of the Forms - Design View and Form View and the Table. As you can see the data in the unbound text box to the right of T1 and T2 are filled in as well as the "Train Name" unbound text box. Now look at the Table view of my table (Manifest4.jpg) after saving and notice that ABV, ABV1, and ABV2 are not filled in. The ABV field is the field I need to use to save the data created.
    Before I loose my mind beating my head against the wall please help with the code or any other pieces I should look at to be able to save the manifests created. I am using W7 Pro and Office 2010. Click image for larger version. 

Name:	Manifest1.JPG 
Views:	7 
Size:	33.1 KB 
ID:	10083Click image for larger version. 

Name:	Manifest2.JPG 
Views:	7 
Size:	17.5 KB 
ID:	10084Click image for larger version. 

Name:	Manifest3.JPG 
Views:	5 
Size:	38.0 KB 
ID:	10085Click image for larger version. 

Name:	Manifest4.JPG 
Views:	5 
Size:	9.4 KB 
ID:	10086

  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,641
    As answered elsewhere:

    If you're using an unbound form (one might ask why), then you must have code or a macro running to save the values to the table. It is in this code/macro that this field would have to be added (or perhaps an append query is being run).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    hawzmolly is offline Advanced Beginner
    Windows 7 Access 2010 32bit
    Join Date
    Oct 2008
    Location
    Green Bay, WI
    Posts
    77
    I got rid of the "ABV" field and replaced it with Field Name "TrainName". With the following code it all works as expected.

    Private Sub Combo161_AfterUpdate()
    Area1 = Combo161.Column(1)
    L1 = Combo161.Column(2)
    T1 = Combo161.Column(3)
    ABV1 = Combo161.Column(4)
    Text172 = Combo161.Column(4)

    End Sub


    Private Sub Combo107_AfterUpdate()
    Area2 = Combo107.Column(1)
    L2 = Combo107.Column(2)
    T2 = Combo107.Column(3)
    ABV2 = Combo107.Column(4)
    Text174 = Combo107.Column(4)
    TrainName = Combo161.Column(4) & "-" & Me.Combo107.Column(4)
    End Sub

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

Similar Threads

  1. Replies: 1
    Last Post: 09-27-2011, 09:42 PM
  2. Replies: 1
    Last Post: 09-27-2011, 09:05 PM
  3. Replies: 1
    Last Post: 07-22-2011, 02:48 PM
  4. Transfer Text to Unbound Form
    By DWS in forum Forms
    Replies: 3
    Last Post: 08-25-2009, 08:04 AM
  5. Transfer text
    By nshaikh in forum Import/Export Data
    Replies: 0
    Last Post: 09-11-2008, 03:27 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