set value and goto record

  • Thread starter Thread starter cporter
  • Start date Start date
C

cporter

I'm running a macro that sets the value of a text box in one form based
off another form and it's relaying the wrong info. When I type in the
value manually it works ok but doing it by macro returns 12/30/1899 or
00:03:35 for some reason

This is the code using in the set value dialog area

item Forms![frmPMprocLO]![Text29]
expression =[Forms]![frmPMByNum]![Dayup]


Also, how do you stop from going to a blank record using the goto
record function?
 
ok, found out the equal sign in the set value expression was a problem.
Not sure why though.

Still don't know how to avoid the empty record set
 
Cporter,

What form are you running the macro on? What event on that form? What
do you have entered in the Dayup textbox on the frmPMByNum form? Is
this textbox bound or unbound? If bound, is it bound to a field with a
Date/Time data type?

As regards GoToRecord action in your macro, what do you have in the
Record argument?
 
Back
Top