Results 1 to 2 of 2
  1. #1
    swavemeisterg is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2012
    Posts
    28

    Use form as a selector to enter data into another form.

    I have a form for users to input specimen data each time a new one is created. One of the fields is 90% of the time one of the same 4 or 5 values depending on the material, while the other 10% of the time it's unique.



    Basically what I want is a "Presets" button that the user can click on which will open a small form with those four or five common materials. When the user clicks on one of those, the value corresponding to that material will be entered into the field on the original form.

    I can easily make this second form, I just need help pushing the data back into the original form. I have no idea how to do this.

    Any suggestions?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    You could modify this:

    http://www.baldyweb.com/WrappedForm.htm

    to use a combo or listbox and pass the selected value back.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 4
    Last Post: 01-18-2013, 02:41 PM
  2. Open form to enter data
    By bharatdubole in forum Forms
    Replies: 2
    Last Post: 12-02-2012, 11:24 PM
  3. Replies: 1
    Last Post: 07-16-2012, 02:10 PM
  4. Replies: 4
    Last Post: 02-27-2012, 10:29 AM
  5. form record selector not working
    By jmk909er in forum Forms
    Replies: 3
    Last Post: 10-21-2010, 08:31 AM

Tags for this Thread

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