Updating info when entering date in form

[Griding]

I have a form and a subform. In the main form I have a date field. In the subform I have a PK, Product, and a calculated field. When I enter a date into the date field it is suppose to update the list of products for that date and give the total for that date. In the after update I placed Me.Requery also
DoCmd.RunCommand acCmdRefreshPage and received a message that Me. and DoCmd. does note exist or was not saved.

In the calcutated field I have
=onHand([pkProductID],Forms!FrmMyDate!InvDateQty)

 

[grgimpy]

Is "onHand" a function you created? Is the subform in datasheet view so that it lists all the records associated with the entered date? If so, where does it show the total, and what exactly is the total of?

You need more details to your question. Also include the error number and description with your problem.

 

[Griding]

Thanks, I did get it to work.

 

[ProgramError]

For those who wish to know.
It did not work because Gridingu put it in the properties for the textbox and not in the VBA code afterupdate Sub routine. The properties saw it as a module and therefore could not find 'me.requery' as a module.

Ian Mayor (UK)
Program Error
If people say I have bad breath, then why do they continue to ask me questions and expect me to answer them?