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

  • Thread starter Thread starter ChrisR
  • Start date Start date
C

ChrisR

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-
 
You'll probably need at least a little VBA coding for this -
are you up for that?
You might also want to consider using a ListBox instead of a subform.
You can then set the ListBox to Multiselect, and select several items in it,
rather than using checkboxes...
 
Actually found someone in my office that has VBA skills and he was able help
me with this and take it up a notch and really make it slick. I gotta learn
VBA apparently.

Thanks for the response,

c-
 
Back
Top