Requery Help

[CO711]

Hi,

I have to cascading combo boxes cboRowField and cboColoumnField. The second dependent on the first one. They they filter the records into a subform. The records come from tblDemo.

I have been struggeling for the last week trying to enter new records. I have been entering the new records in tblDemo. But then the new records aren't available in the combo boxes. I know its probably a requery problem but what code do I enter and where do I enter it? Am I entering the new data in the right place or should I be entering it somewhere else?

Thanks for your time and help.

 

[boblarson]

I'm hoping you are entering this data via a FORM and not directly in the table and that the combos you are talking about are on a form and not as lookups in the table. Can you confirm that first?

 

[CO711]

I'm hoping you are entering this data via a FORM and not directly in the table and that the combos you are talking about are on a form and not as lookups in the table. Can you confirm that first?

That is correct. I wasen't sure if there was a better way to do it.