Command button to preload data fields in subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a 'picture' of a foot and want to put a command button in each toe
which when clicked will load two data fields in a subform and shift focus to
the other fields. ie Right foot Big Toe button will preload "Right" into
LRFoot field and "Big Toe" into Site field Then move focus to procedure
field.
Any suggestions a) How to do it ?
b) An easier or different way.
Thanks
Eric
 
Eric,

I think this is what you want... on the Click event of the example
command button:

Me.LRFoot = "Right"
Me.Site = "Big toe"
Me.Procedure.SetFocus
 
Back
Top