+ Reply to Thread
Results 1 to 2 of 2

VBA Edit button only works correctly through Get Contact button but not search text box

  1. #1
    Registered User
    Join Date
    02-28-2020
    Location
    Northern Ireland
    MS-Off Ver
    2010
    Posts
    6

    VBA Edit button only works correctly through Get Contact button but not search text box

    Any help greatly appreciated I’m new to VBA and cannot resolve the following:

    If I open form and select Get Contact button all results are returned in the listbox beneath the button, then if I double click an entry it goes into the text boxes, I can then change values in the text boxes and then select the Edit contact button all items return to the listbox updated.
    The problem I have is the search for textbox at the top of the form, if I type it will return the results in the listbox and I can still double click an entry so it goes into the textbox’s at the bottom of the screen, I can still change values in the text boxes and then select the Edit contact button and all appears to work all items are returned to the listbox, however the original entry is still there and on of the other entries has been updated???

    I have uploaded the form etc along with the code to see if anyone can see what the issue is
    Attached Files Attached Files

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: VBA Edit button only works correctly through Get Contact button but not search text bo

    Can you expand further as I cannot see the problem all seems to work OK - the form closing could be cleaner with an autosave.
    torachan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. (SOLVED) Please add Search / Edit and Update Button
    By Stona in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-25-2020, 09:54 AM
  2. Search and Edit Form, Search not working correctly
    By rob_h in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2017, 03:48 PM
  3. Button to search for a File based off of button Text
    By ExcelnExcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2013, 10:43 PM
  4. Macro works correctly from VBE but not from button
    By tone640 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2012, 10:45 AM
  5. Replies: 2
    Last Post: 03-12-2008, 06:52 PM
  6. contact email button
    By javajon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2008, 04:56 PM
  7. Replies: 1
    Last Post: 02-22-2005, 10:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1