Form,Query Question

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

--
I have a form based on a Query, the Tubular form contains a number of
Client with a Combo Box with a Row Source Type / Value List, and Row
source Yes;No
Is it possible to change the Combo box on this form from say Yes to No so as
the original table changes for that ClientsID
Thanks for any help......Bob
 
Hi, Bob

Change it in the On Current event of the *form*

Me.MyCombo.RowSource={original row source of combo} WHERE [YesNoField]="No"
Me.MyCombo.Requery

Regards
Jacob
 
Back
Top