I have this view that has fields from 2 tables:

BATCH.BANUMBER and PRODUCT.PRNAME

These 2 tables are linked by BATCH.BAPRID = PRODUCT.PRID

I created the view and use it on a form as the source for a Combo Box.
This works fine but..

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.

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