Results 1 to 2 of 2
  1. #1
    bbrazeau is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    101

    Accept user input to populate new record

    Tables: tblCustomers, tblParts, tblToolRfqs



    Relations: 1 to many-Customers to Parts

    Forms: frmMain- has bound combo boxes for Customers, Parts(1+2), and txtboxes for PartCounts(1+2). also cmdbutton to open frmToolRfqs in add mode.
    frmToolRfqs-Has txtfields set to "Format"=general number, 0 decimal points for Customers,Part1,Part2,Part1Count,Part2Count.

    Notes: fields in tblToolRfqs are not related to Customers or Parts. Customer combobox on frmMain filters Part comboboxes with only chosen Customers Parts. Some times Part2/Part2Count will not be needed.

    I would like to be able to fill in the combo and txt boxes on frmMain and press cmdbutton which would validate input ,open the frmToolRfqs and fill in the fields,then lock them from being edited. Any help would be appreciated. I know that table normalization would suggest seperating Part1 and 2 in tblToolRfqs through a tblToollRfqDetails, but there can be many tblRFqs scenerio combinations per project before one is actually settled on and then all the others will be deleted. Also, I may actually add one more Part/PartCount set of fields to frmMain and tblRfqs.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    All can certainly be done with VBA code. User needs to input data to frmToolRfqs?

    A form/subform arrangement is not appropriate?

    Want to provide project for analysis?
    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.

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

Similar Threads

  1. Replies: 8
    Last Post: 12-05-2011, 01:55 PM
  2. Find duplicates query to populate input form
    By kctalent in forum Queries
    Replies: 6
    Last Post: 08-22-2011, 03:12 PM
  3. How to take a user input
    By iamraja5 in forum Access
    Replies: 1
    Last Post: 05-12-2011, 10:17 AM
  4. Replies: 3
    Last Post: 08-25-2010, 09:03 AM
  5. User Input Query
    By ManC in forum Queries
    Replies: 2
    Last Post: 03-04-2010, 07:09 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