How to show certain choices in drop down list 1

[LouieGrandie]

Have a form where I have a field that is a drop down and list % of completion. 0, 25,50,75 and 100. However I do not want the 100 to show up unless another field, a check box for completion, is checked. Is that possible. Is it possible to show certain choices depending upon the value of another control on the form?

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[BTSTeam]

Maybe something in the GotFocus event, like:

Private Sub ComboName_GotFocus()
If CheckBoxName = "True" Then
ListName.RowSource = "0,25,50,75,100"
Else
ListName.RowSource = "0,25,50,75"
End If
End Sub

(With the control RowSourceType property set to Value List)

 

[LouieGrandie]

Close but when I click on the field it returns an error message of:

Run time error 424 Object Required and the line ListName.RowSource = "0,25,50,75" is highlighted.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[dhookom]

LouieGrandie,
Did you change the names of the controls to match the names of your controls?
I would also change:

If CheckBoxName = "True" Then

to

If CheckBoxName = True Then

Duane
Hook'D on Access
MS Access MVP

 

[LouieGrandie]

Thanks for the help. Works fine. Rookie mistake. While I changed the name of the CheckBoxName I forgot to change ListName to the name of the field. Once I did that it worked like a charm.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[LouieGrandie]

Just realized that there is no way for the end user to edit the list. I was wondering if there is a way to code it so that is one thing is true then it uses Table1 as the source and if it is false then use Table2. I tried changing

Percent.RowSource = Table1 but that doesn't work.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[dhookom]

I never use a value list for row sources because I assume a list will change over time. Why not just create a small table and stick with it?

Duane
Hook'D on Access
MS Access MVP

 

[LouieGrandie]

Because the client wants it so that if a box it checked they see one list and if it is not checked they see another list. Also on another part of the form they want it so that if they select 1 from a drop down list they see one list and if the select 2 they see a completely different drop down list.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[dhookom]

You can easily change the Row Source if the type is "table/query". Use code to change the SQL statement in the Row Source property.

Duane
Hook'D on Access
MS Access MVP