Having Select Data Fields Showing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I would like only certain fields to be visible to the user after they
enter a certain thing i.e. if the OurProjectNumber = 0080, then I would like
the fields cboWorkType to be "INS" and the field CityContractNo to =
123456789.

I landed on the OurProjectNumber field and selected 'After Update' and
entered:

If OurProjectNumber = 0080 Then
cboWorkType = "INS"
cboCityContractNo = "123456789" but the the fields won't populate. In each
case those fields are drop down boxes with column numbers, both are Column
(1). I tried adding that and it still won't populate.

Can anyone help me figure out what I am missing.

Thank you,
IEJ
 
Hi,
If you're going to hard code this, simply use the value of the bound column of the combo box.
That will work.
 
Thank you for replying but I'm afraid I don't understand. I just want these
values to repopulate so the user doesn't have to select them from the
dropdown. When you say 'hard code this', is there something unusual about
doing this, making only certain fields visible when another field is chosen.
What I'm not clear on is why what I have written won't work, is it that it is
not in the right place or written incorrectly.

Thanks,
IEJ
 
Hi,
How many columns do does your combo have?
It sounds like you are trying to set a value for something other than the bound column.
Look in the combo's property sheet to determine all this.
 
Back
Top