Combo Box Not Sync'ing with Filter

[LarryDeLaruelle]

I have set up a simple form with a combo box based on the underlying table.&nbsp;&nbsp;Works fine.<br><br>Also on the form are a set of options buttons (created with the wizard) to filter the recordset.&nbsp;&nbsp;Works fine at least as far as the navigator information indicates (I get the correct number of filtered records).<br><br>However . . .<br><br>The combo box continues to list all of the records in the recordset rather than only those returned from the filter.<br><br>Any suggestions on how I can syncronize the combo box to the results of the filter?<br><br>Thanks. <p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br>

 

[Sensibilium]

You need to requery the combo box, whenever one of the radio buttons is changed.<br><br>eg:<br><FONT FACE=monospace>cboYourComboBox.Requery</font><br><br>That should do it... <p>ahdkaw<br><a href=mailto:ahdkaw@sensibilium.com>ahdkaw@sensibilium.com</a><br><a href=

http://sensibilium.com/>Sensibilium</a><br>'If

you do visit my sites - be warned! You must be of a discordian nature...'

 

[LarryDeLaruelle]

Thanks, but I tried that first and it still shows all records in the combo box.<br><br>I think that may be due to the query Access created (row source property) when I created the combo box -- it looks at all the records from the table with no criteria to limit the selection.<br><br>I've also tried to set the combo box equal to the filter and it still shows all records.&nbsp;&nbsp;I even tried combobox.rowsource = filter and get no records from that.<br><br>It's a puzzler. <p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br>