Microsoft Access: Using Checkboxes on Form to Determine/Summarize Options in Combo box/Drop down on Different Form

-

[NOT FINISHED. Couldn't save as draft so only option was to upload]



I have a form for entering material types and the main data entry form. 

On the main data entry form we have a combo box/drop down of tasks and materials. 

We only use certain materials for certain tasks, so I want to reduce the combo box based on my selection. 

I have only 8 tasks and over 20 materials; so it makes sense for me to put the task selections with the materials form

Record Source: tbl_materials
Form Type: Single Form




Added Task 11 and task 12 as extra (blank) just in case we add more tasks









Combo_task_type_AfterUpdate()

If Me.Combo_task_type = 1 Then
    Me.combo_materials.RowSource = "SELECT material_id,material_type,status_id,task1 FROM tbl_materials WHERE task1= True ORDER BY tbl_materials.material_type;"
    Me.combo_materials.Requery

   End Sub







Comments

Post a Comment

Popular posts from this blog

MS Access : Report Sorting by Count

-
Image
 Someone on StackOverflow had a question: I've created an Access report that is grouped by a person identifier and then displays all the rows in the source query related to that person identifier. I want to sort my report output by the person with the least number of rows to the person with the most number of rows. Here's the data: They had 3 different PersonID.  id123456 id234567 id23456789  They wanted to sort by PersonID with the least amount of rows on top.  So I made a replica of their table called  tbl_people  (and I added p# at the end of each field to make sure the data was going to the right area of the report. so p1 is for Person1, p2: Person2, p3: Person3) -close and save- Then using the Query Builder, I added  tbl_people  and added  PersonID   TWICE.  Click the totals button towards the top; then change the first column from Group By to  Count  and make the  Sort: Ascending  (and I ended up naming it ...
Read more