Results 1 to 3 of 3
  1. #1
    toollady22 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2014
    Location
    Newport News
    Posts
    3

    Using macro

    I am basically a newbie. I have created a database for a friend; tested each table and form he needs to keep track of his home business info in another table. When he selects business from the combobox in the main form I would like to have the subform popup with the fields already filled in from the main form. is this possible. Also I tried a macro open form; form name=business frm; where condition=business. It pops up form but asks Enter parameter value
    Attached Thumbnails Attached Thumbnails parameter error.jpg   2nd form.jpg   Mainform.jpg   Macro.jpg  

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    The WHERE CONDITION is used to filter records. It requires a field to search and a parameter to search for. Say you want a form to show record for customer named ABC Sales and that customer ID is 457.

    WHERE CONDITION: =[CustomerID]=457
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    toollady22 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2014
    Location
    Newport News
    Posts
    3
    Thank you June7

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

Similar Threads

  1. Command Button to Run Macro, can't find macro
    By Ace2014 in forum Modules
    Replies: 22
    Last Post: 06-11-2014, 11:42 AM
  2. Replies: 2
    Last Post: 06-30-2013, 09:59 AM
  3. Replies: 2
    Last Post: 05-05-2012, 02:34 AM
  4. Need help with macro
    By zaza123 in forum Programming
    Replies: 0
    Last Post: 07-06-2011, 09:26 PM
  5. Replies: 0
    Last Post: 01-12-2011, 12:43 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