Help with ideal

[David Ehrenreich]

Hello,

In one of my forms I have a sub-form displayed as a
datasheet. This sub-form is unbound. It's purpose is to
let our proctors see what students have signed in. When a
proctor needs to bring up a students record they find that
students social security in the sub-form(datasheet), and
then enter the number. I was wondering is their a way the
user could click on the ssn feild and the ssn number would
be copied to a feild in the main form. We have been
cutting and pasting, but I would like this process to be
automatic.

Any help would be great

 

[Steve Coombes]

Hi David -

Try using either the Click or DoubleClick event of the field (or better yet,
consider adding a command button to make it more obvious), and add code like
this to your subform's event:

' Rename the fields as appropriate
Me.Parent.txtParentFormSSN = Me.txtSubFormSSN