New to forms. Want to use checkbox for selecting from list.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am looking to have a form and sub form linked so that the user can choose
a Vendor from a dropdown and then the subform will requery to show the list
of LoadID's currently open for that Vendor. Then I would like them to be
able to put a checkbox next to the LoadID's they wish to add comments for
all at once (apply same comments to multiple LoadID's).

Completely new to subforms and checkboxes.

Source table will have field Vendor and LoadID along with blank fields
waiting for comments to be input. In theory the user would select a Vendor
(dropdown), then which LoadIDs they want to apply the comments to (checkbox
in subform?), add comments once and apply to any Vendor/LoadID selected.

Sure it cant be that hard but most of my experience is in query/macro
building in the back and less with front end stuff for other users. Any
help would be greatly appreciated.

c-


.

Relevant Pages

  • Re: Open new record subform for data entry
    ... The other thing you may need to check is that AVInvoicedataentrysubf is the name of the subform control on the main form, as against the name of the form that is being used for the suform - these are not necessarily the same. ... I want to enter in a PO# and have the vendor assigned to that PO Populate the Vendor Field in my Invoice Form so confirm for the data entry person that this Vendor does in fact belong to this PO. ...
    (microsoft.public.access.forms)
  • Validation to assure there is a subform record
    ... the PO table and a subform based on a LineItems table. ... subform control to add a LineItem record. ... The PO system is tied in with a Vendor database. ... of the vendor information appears in a subform. ...
    (microsoft.public.access.formscoding)
  • Re: BruceM or Douglas J Steele
    ... see all of the categories at once for a particular vendor. ... if you use the subform to select three categories for that vendor, ... You link vendors and categories in the junction ... >> That combo box's row source will be based on tblCategory. ...
    (microsoft.public.access.gettingstarted)
  • Re: display prior and add new records
    ... My subform updates a table set up to track commodity increases. ... SecCommID and once the user selects a Vendor from the list box these fields ... estimated increase %,and date of increase, and reason. ... CommodityID of steel will go up 3%, on the same date, for the same reason) ...
    (microsoft.public.access.forms)
  • Re: sub-forms
    ... subform, but not 2 subforms, I will try designing it in design view. ... drag'n'drop the TicketDetails form from the db window onto the TicketOrder ... tblticketorder and tblticketdetails as ONE subform. ... the vendor. ...
    (microsoft.public.access.gettingstarted)