Auto filling and keep drop down

[Jay Dave via AccessMonster.com]

I have 2 combo boxes with both drop downs, call them CLIENT and MACH TYPE.
I want to auto fill in MACH TYPE when CLIENT IS filled. I have no problems
with that, but I want to be able to keep the the drop down menu for MACH
TYPE. In order to auto fill I have 'bound column' set to 1 and 'Limit to
list' as No. But when I try to select from drop down when client is filled
it says "Control cant be edited; Its bound to the expression 'Whatever is
displayed'" Is it possible to do auto fill and keep drop down menu for a
combo box?

Thanks in advance,
JD

 

[Ken Snell [MVP]]

Sounds as if the Control Source for MACH TYPE combo box is an expression or
is a calculated field in a query or is an autonumber field. You cannot
change the value of MACH TYPE in those cases.

Tell us more about MACH TYPE combo box's properties.

 

[Jay Dave via AccessMonster.com]

The row source type is set to Table/Query, dont know what other properties
you need to know. Is it possible to have the auto fill and keep the drop
down though?

 

[Ken Snell [MVP]]

I mentioned the Control Source in my reply. What is that property's value?

 

[Jay Dave via AccessMonster.com]

OH yeah I have some code for the Client AfterUpdate so that the MACH TYPE
control Source changes to the appropriate value when Client is changed. I
have Cases and for each option of Client, I have
Me.MACH_TYPE.ControlSource = "='Blah'"

Is that not the way to do auto fill if I want to keep drop down?

 

[Ken Snell [MVP]]

Is your question how can you provide an initial value in the combo box,
based on what is selected in the first combo box, and still let the person
select a different item in the second combo box's dropdown list?

If yes, then the Control Source property will need to be blank. And change
your code to assign a value to the combo box instead of changing the control
source expression. Something like this, perhaps:

Private Sub Client_AfterUpdate()
Me.[MACH TYPE].Value = "ValueToUse"
End Sub