Set value of key field in next form

  • Thread starter Thread starter Sheila D
  • Start date Start date
S

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
 
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
 
Back
Top