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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box Question 2
Access Control on subform / combo box requesting parameter 0
Problem with Combo box on form 1
Help with this Search button 3
Combo Box QUESTION 5
Combo Box Enable Question! 9
Blank combo or list box 1
Combo Box Question 4

Back
Top