Autofill

  • Thread starter Thread starter matt22
  • Start date Start date
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 (e-mail address removed)
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
 
Hi,

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

me.NameEmailControl = me.NameIDControl & "(e-mail address removed)"

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