Auto filling and keep drop down

  • Thread starter Thread starter Jay Dave via AccessMonster.com
  • Start date Start date
J

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
 
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.
 
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?
 
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?
 
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
 
Back
Top