Results 1 to 6 of 6
  1. #1
    rici7 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    6

    Recods from one form in second form

    Hello,



    can anybody help me with this problem? I have table with customers, form with list of those customers and form with details of customers. I want to create macro which open the customer details form after clicking on customer name in the customer list but with details of customer on which I have clicked.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Is there a reason you want a different form to open with the customer details instead of using a form/subform arrangment?

  3. #3
    rici7 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    6
    The reason is that first form is just list with customer name and address but in the form customers details is more informations from another table.

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    That's exactly what a form/subform is intended to help with. If your second table has the customerID unique key field stored in it you can make a form/subform where all the information on the second table is displayed on the same form with the customer and you can look at all the records without having to use a second form.

  5. #5
    rici7 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    6
    Yes but my problem is that I need in each forms different data. But if I use form/subform, I can choose only same fields for booth forms.

  6. #6
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    I don't understand. Perhaps if you attached a copy of your database with sample data in it instead of real data it might be more helpful.

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

Similar Threads

  1. Replies: 1
    Last Post: 08-19-2011, 02:53 PM
  2. Replies: 9
    Last Post: 02-15-2011, 03:05 PM
  3. Replies: 1
    Last Post: 11-07-2010, 11:04 AM
  4. Replies: 0
    Last Post: 05-09-2010, 08:43 AM
  5. Replies: 9
    Last Post: 03-24-2009, 09:19 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