query, use of max

  • Thread starter Thread starter Chrissy
  • Start date Start date
C

Chrissy

I have a query that uses the Max function (InvMax). I
display that on a form (frmMain) via a subform (sfrm). My
form (frmMain) has an unbound control (NewInvMax) that I
need to set equal to InvMax +1. I do this in combo box's
after update event.

My code is: NewInvMax = Me!sfrm.form!InvMax +1.

It returns "You entered an expression that has no
value." Yet InvMax shows a value. If I remove the
statement form works without the incrementing, of course.

Is this a Max problem? Combo box? Requery?

I'm lost.

Any help is appreciated. Thanks.
Chrissy
 
Thanks. I used NewInvMax = Me!sfrm!InvMax + 1

I now get "automation error".

Where do I go from here?
 
Back
Top