Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2008

    3 questions about forms

    Make that two questions.

    I used to be pretty familiar with Access, but it's been about five years since I've used it and I've forgotten a lot. I'm trying to help my new office make the best use of the program by making a new database. We're using Access2000. Here are my questions and thanks in advance. Help with any of them would be much appreciated!

    1. I have a main client list form (frmAllClientList) and I want to be able to double click on a record and open frmBasicContact, showing only the selected record, not all of them. What should I do for the Double Click event that will allow me to filter for the current record?

    2. I have a data entry form (frmCltDataEntry) that is pulled up by a button on frmAllClientList. How can I make frmAllClientList refresh after frmCltDataEntry is closed? Is it part of the close event for the data entry form, or the active event for the list form? (For that matter, it would be nice to have it refresh when any other form is closed and the main form is shown again.)

    Thanks again, experts. I've looked everywhere to try and figure these out!
    Last edited by surfer_rosa; 10-09-2008 at 08:28 AM. Reason: Figured out one of them!

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

Similar Threads

  1. newbie questions
    By bigmac in forum Access
    Replies: 0
    Last Post: 10-07-2008, 12:53 AM
  2. New to Access and have questions
    By MichelleFinn in forum Access
    Replies: 1
    Last Post: 04-04-2008, 06:30 PM
  3. Replies: 2
    Last Post: 11-17-2006, 01:07 PM
  4. Replies: 2
    Last Post: 06-12-2006, 08:37 AM
  5. New to this forum and have questions
    By Sinatra Fan in forum Access
    Replies: 4
    Last Post: 04-14-2006, 06:53 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 - Senior Forums