+ Reply to Thread
Results 1 to 1 of 1

Open to record containing value entered in field

  1. #1
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Open to record containing value entered in field

    Hi,

    Hope the title makes sense.

    I am trying to get a form to open to a record containing the SSN that is entered in another form.

    The idea is that upon entering new employee information the SSN is compared to the existing data to determine if it is already in the table.

    I am using a DCOUNT to do that in a macro. It works.

    What I can't figure out is the next step in the macro that opens the other form so that the record with the SSN is displayed.
    Also want the macro to close the previous form without giving an error.

    The Emp Data form contains the SSN textbox with On Exit macro to:

    If: DCOUNT
    OpenForm : Table2
    CloseWindow : Emp Data

    It opens the Table2 form, but not to the record corresponding to the SSN entered.

    Gives an error when it is supposed to be closing the Emp Data form after the Table2 form is opened.

    Attached is a zipped copy of my experimental file.

    Hope this make sense and someone can show me how simple it is.

    Thanks,
    Attached Files Attached Files

+ 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. how to find last record entered??
    By ntambomvu in forum Excel General
    Replies: 5
    Last Post: 07-02-2015, 09:42 AM
  2. [SOLVED] Verify data has been entered before adding new record
    By randolphoralph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2015, 01:52 PM
  3. [SOLVED] Return Last the record entered for a specific name.
    By JO505 in forum Excel General
    Replies: 10
    Last Post: 09-14-2014, 02:05 PM
  4. [SOLVED] Insert Row and Record in Another Sheet Once I entered date
    By atulexel79 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-22-2014, 10:04 AM
  5. Replies: 6
    Last Post: 06-02-2014, 04:47 PM
  6. Ensure that a unique record is entered
    By Rocketman66 in forum Excel General
    Replies: 1
    Last Post: 07-15-2010, 05:47 AM
  7. Unlocking a field once an entry field has been entered
    By jodders in forum Excel General
    Replies: 2
    Last Post: 03-31-2008, 07:52 AM

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