DCount realtime

[Patience]

Hi guys,



I have a DCount function which counts the number of identical records and shows the result in a form. The code is this:

=DCount("Version";("Tabel - Textile data and test results");("[Code] = Formularer![Textile overview]![Code]"))

However, I need this calculation to be performed when the fields for a new record is being filled. That is before the record is saved.

So when the user enters a number in field A and exits the field, then the DCount calculates and instantly shows the result.

I have tried entering the DCount function in AfterUpdate, Beforeupdate and all the others, but I can not get it to work. It only works when existing records are shown in the form.

How can I get around this?

Thanks a lot!

BR

[Datagopherdan]

You can requery the form. You would also need to add some code, so the user would return to the record they were on.

Hi guys,

I have a DCount function which counts the number of identical records and shows the result in a form. The code is this:

=DCount("Version";("Tabel - Textile data and test results");("[Code] = Formularer![Textile overview]![Code]"))

However, I need this calculation to be performed when the fields for a new record is being filled. That is before the record is saved.

So when the user enters a number in field A and exits the field, then the DCount calculates and instantly shows the result.

I have tried entering the DCount function in AfterUpdate, Beforeupdate and all the others, but I can not get it to work. It only works when existing records are shown in the form.

How can I get around this?

Thanks a lot!

BR

[Patience]

Thank you Dan, but I can not do that since many fields in the form are mandatory, so when I requery the form, it informs that not all mandatory fields have been filled.