>The combo box will not reflect the current status of the batch or product tables. For instance if I ADD a new BATCH record and link it to a product, there should now be a new record in the combo dropdown. But despite doing a cmbCombo.REQUERY this is not so. The same with a BROWSE of the view as also when a record is deleted or edited.
REQUERY in combobox is intended if your rowsourcetype is SQL. In your case, you are using a View as rowsource which requires rowsourcetype as Alias or Fields. REQUERY the view and it updates the combobox content automatically. I assume that the View is parameterized.
>IS there a way to make the view update with changes made to either PRODUCT or BATCH table so the combobox always displays the current data?
>
>I have tried everything possible in the view designer but cannot get this to work.
>
>Bernatd
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."