Updating a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a main form that allows users to enter in payments received from a
particular debtor, and a subform that should show the invoices that are
outstanding when the debtor is selected via a combo box on the main form.

The subform doesn't seem to update at all and I have to do it manually
(pressing F9). I've checked the parent/child link fields and they are the
same (linked via Debtor_No).

Can anyone help me here, quite desperate!

Regards
 
On the AfterUpdate event on the Combo Box add the following code

Me![Subform Name].Requery
 
Hi, I tried that, but it doesn't work. There is no error message or
anything, it just doesn't show anything until I actually go into it and
manually requery it.

Any other ideas?

Thanks.

Dennis said:
On the AfterUpdate event on the Combo Box add the following code

Me![Subform Name].Requery

winsa said:
Hi

I have a main form that allows users to enter in payments received from a
particular debtor, and a subform that should show the invoices that are
outstanding when the debtor is selected via a combo box on the main form.

The subform doesn't seem to update at all and I have to do it manually
(pressing F9). I've checked the parent/child link fields and they are the
same (linked via Debtor_No).

Can anyone help me here, quite desperate!

Regards
Click to expand...
Click to expand...
 
Back
Top