Set value of key field in next form

[Sheila D]

I have a form which collects date for different hospital procedures.
Depending on the type of procedure I need different forms to ope which I have
done using a macro to check the value on the after update property of the
field and then open the relevant form. (I'm not a VB person!)

What I would like to do in the new form is automate the Procedure number
already entered on the first form. I've tried using SetValue action in a
macro on the On Open action for the formto refer back to the first form field
but get an error saying I can't assign a value to the item.

Any help much appreciated
Sheila

 

[Jeanette Cunningham]

Sheila,
usually, the On Open event doesn't work for this, but the Load event does.
Put your macro on the form's Load event and try it.


Jeanette Cunningham -- Melbourne Victoria Australia