Autofill

M

matt22

Hello,

I am building a database and I have an ID field which is a number. I need
this number to automatically transfer into other fields but at the start of
some text for email purposes.
For example ID 11223
then goes into email 1 field as [email protected]
In excel I can get this to work but cannot seem to do it in access.

Also I am struggling to stop scrolling through records when I use the mouse
wheel is there a way I can stop this
 
N

NG

Hi,

just put a code in the afterupdate property of the ID field similar to :

me.NameEmailControl = me.NameIDControl & "[email protected]"

If the id field is an autonumber the afterupdate won't be triggered, but
then you can put the necessary code in the beforeinsert property of the form
 
Top