Search results

Have you got a query (with a criteria) ?? Did the subform link on this query ??

Hello binbin! As you can see, there are more ways for do this. you can chose what you want.

Her it is (attachment, zip) Open form "frmInvoice" and see.

In Form Load event put the code. DoCmd.GoToRecord,,acNewRec

Yo don't need to save calculated value, because you can calculate it always you need it.

FORM BEFORE UPDATE event

Try via BEFORE UPDATE event.

Look at DateFilterDB.zip (attachment, zip) Open form and try. I forgot, look at "RECORD SOURCE" (in the form).

Look at "Demo4ComboA2000.mdb" (attachment, zip). Open Form and try. Adapt it in your MDB.

Look at "RELATIONSHIPS", (Attachment, word, zip).

Try to do it via NZ function.

In the PROPERTIES (for the combo box) LIMIT TO LIST put NO, (instead of YES).

In your first thread. "After Update" event Forms!frmMainForm.txtTotalPrice.Requery

Try this: Delete this line in "After update" event.

Try to do it in Sub Form_Current, (On current event). I don't know exactly, because I don't know your task.

Try to do it via DLookup function.

No, I can't open it.

I can't to read this. It is not Access2000 or 2002-2003.

Try this: In the CONTROL SOURCE poropeties (in Total field) put: =Sum([Name of the field]) I think "Name of the field" is "Total product cost", without a sign ".

Send a short example of your mdb, (Access2000 or 2002-2003).