Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008

    In a field on a Form, on click open another form

    I dont know much about microsoft access

    I created a form. In that form, I have a field that is looking up another field/s on another form. Once found/selected I would like it to open up another form with the selected file by double-clicking on the field.

    Please help....I need a step by step instructions

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Personally, I would use a command button and take advantage of the command button wizard. You can select which form you want to open and select which field to base the new form on.

    If you still wish to open the new form by double clicking on the field, I would copy and paste the code generated from the command button to the double click event for that field.

    If you need more info, just let me know.

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

Similar Threads

  1. Mouse click to open form
    By darryl.charles in forum Programming
    Replies: 0
    Last Post: 09-05-2008, 10:33 AM
  2. Replies: 1
    Last Post: 08-27-2008, 12:39 AM
  3. Form will not open
    By dserbanescu in forum Forms
    Replies: 0
    Last Post: 01-09-2008, 09:48 AM
  4. Using combo box to open another form
    By ladyairj23 in forum Forms
    Replies: 0
    Last Post: 06-02-2006, 07:03 AM
  5. Open a form from a web page
    By Karyn-2000 in forum Programming
    Replies: 0
    Last Post: 04-21-2006, 07:35 AM

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