Results 1 to 2 of 2
  1. #1
    REAbernathy is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2012
    Posts
    46

    Information is not showing up on form for me to update

    I have a form that I created and i have a text box on the form that will allow the user to enter the Retrieve Batch Number and if they hit the Find Record button this should show the information on the form that was entered. Under the Find Record button i have this query SELECT * FROM [CMAS-TEST] WHERE ((([CMAS-TEST].Batch_CMAS) Like [Forms]![Retrieve_Batch_CMAS]![Batch_CMAS] & "*")); however its working but not like i want it to work. What happen is when i enter the number in the Retrieve Batch Number and hit Find Record the database opens up and shows me the correct information but i want the information to show on the form. What I am doing wrong on this can someone help me?



    Thanking You in Advance for you assistance on this matter.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    This might be what you are trying to do http://datapigtechnologies.com/flash...tomfilter.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Combo Box to Update Tabbed Information ona Form
    By JessicaNicole in forum Access
    Replies: 3
    Last Post: 08-30-2012, 01:56 PM
  2. Form not showing information in querry
    By srmezick in forum Forms
    Replies: 3
    Last Post: 11-15-2011, 01:39 PM
  3. Replies: 5
    Last Post: 10-27-2011, 10:25 AM
  4. Replies: 2
    Last Post: 10-11-2010, 09:09 AM
  5. Replies: 4
    Last Post: 09-03-2009, 02:01 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