>>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
Thanks for your reply. NO. The cursor is not Parametzed. I "MODI DATABASE" the DBC and added a "Local View" using the Wizard. Does this change anything?
Other than that, your suggestion works perfectly. I looked it up in HELP.
Thank You
Bernard