Refresh a subform

[MikiH]

Hi all

I've got a combobox on a subform which looks updata and updates fields. ie

combo orderno(unbound) orderno (bound)
partno (bound)


I've set the combo to "limit to list", when new data is not in the list opens new form to enter data. Then returns to subform.

When I run the database on a local harddrive this works fine but I need to run it on the network and it gives me the following error when updating the bound fields:

cann't find record in table ....

If I go into the main form and then refresh the data it works again. Any idea on how to refresh the subform?

Thanks
(working with Acc 97)

 

[Gazonice]

When the sub form closes, you could use a Refresh there:

OnClose:

Forms![MainForm].ReFresh

Regards

Garry

 

[MikiH]

Thanks

But I don't close the subform the new form is popup and modal.

 

[Gazonice]

Hi,

perhaps you could try OnLostFocus.

Gaz