Results 1 to 2 of 2
  1. #1
    hendrikbez is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2014
    Posts
    138

    Shoiw info in second textbox

    I have two textboxes on my form, so when I put info in textbox 1 and go to next texbox it must show me info like UNIX in the second box.
    I did try this code, but is getting compile error, "Expected:list seperator or" at IN
    I am not so good with vba at the moment



    Code:
    Private Sub cmdSystem_Click()
    DisplayText: IIf(Eval([Tapes] In ("AAG*","NSW*","NJQ*")),"UNIX"," ")
    End Sub

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    What is it in the code you have written that references textbox1 or the next textbox?

    I suggest you look at some vba functions and code examples to get a better understanding of the concepts.
    Good starting point is FunctionX

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

Similar Threads

  1. How to show textbox info in a messagebox
    By hendrikbez in forum Macros
    Replies: 1
    Last Post: 12-03-2014, 09:57 AM
  2. Filter a database based on a textbox info
    By charly.csh in forum Access
    Replies: 4
    Last Post: 11-20-2014, 02:24 PM
  3. Textbox displays info but can not edit.
    By Yiannis in forum Forms
    Replies: 3
    Last Post: 11-16-2012, 01:34 PM
  4. Replies: 3
    Last Post: 10-24-2012, 05:41 PM
  5. Replies: 4
    Last Post: 07-07-2012, 07:14 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