requery a subform

[gwilym40]

I've seen loads of posts about this, none of which work for me.
I have a main form with 2 sub-forms
double-clicking a field in one subform runs an insert into statement which updates the 2nd sub-form. However its only when you move forward a record and back again that the 2ns sub-form is requeried.
I've tried loadfs of things on the after-update, refreshing the recordset - nothing works
any ideas much appreciated

Regards

 

[KenReay]

Hi

In the double click event wheer you have the SQL Update, have you tried putting SubFormControl.Requery
where subform is the name of the second form subform control

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[gwilym40]

yeah I've tried that but no luck