Results 1 to 2 of 2
  1. #1
    justinwright is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    104

    Concatenating (2x unbound into bound text box)

    I've read similiar articles, and tried solutions on each, but for some reason none of it is working

    I have three boxes

    1) Explanation
    2) chknum (check number)
    3) ditm (date item)

    It's usually either chknum or ditm, but it can be neither. I have an if statement changing the visibility of the boxes based on if it's needed or not.



    Regardless, I want to concatenate the applicable item into a box that's bound to a table (it's interfacing with an older program, long story).

    Sample code is as follows:

    Code:
    If Me.Explanation.Value = "VOID" Then
    Me.Concatenated.Value = [chknum] & " " & [Explanation]
    End If
    Whenever I do that, it still returns just "VOID" in the box, nothing else

    I've also tried:

    Code:
    If Me.Explanation.Value = "VOID" Then
    Me.Concatenated.Value = Format([chknum], "00000000") & " " & [Explanation]
    End If
    Any help is much appreciated!

  2. #2
    justinwright is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    104
    Sorry for the double post, but I narrowed it down. I have an option for a custom reason, and if so I just wanted it to put that reason in the concatenated box. The code is as follows

    Code:
    If Me.Explanation.Value = Null Then
    Me.Concatenated.Value = " "
    Else
    Me.Concatenated.Value = Me.Explanation.Value
    End If
    I had put that AFTER all of my other code, unlike putting it first like I should have. I figured I'd post this in case someone did something retarded like I just did, maybe it will help someone else too .

    Thanks anyways guys!

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

Similar Threads

  1. Replies: 3
    Last Post: 08-08-2010, 12:21 PM
  2. Replies: 1
    Last Post: 08-05-2010, 12:11 PM
  3. Replies: 0
    Last Post: 05-09-2010, 08:43 AM
  4. Bound a unbound text box to the table
    By Brian62 in forum Forms
    Replies: 1
    Last Post: 11-06-2009, 11:05 AM
  5. Link unbound form to bound form
    By Papote in forum Forms
    Replies: 0
    Last Post: 09-25-2008, 07:42 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