update fields when entering date

[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)

 

[johnwm]

Hi and welcome to Tek-Tips. Please read faq222-2244 carefully to see how these forums work best.

Is this a true VB6 app, or is it done in Access VBA? If it's Access VBA (which it looks like since you're using Access constants) then repost in one of the Access forums, maybe forum705. If it is VB6 then you need to explain how you are referencing DoCmd and Access constants.

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[Griding]

This is done in access.