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 (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
 
N

NG

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mouse scrolling in a form causing problems 2
Autofill Day of the Week 6
Access Automatically Send a notification email once a record is added 0
move records to different fields within table 3
Access mouse wheel does not scroll in datasheet view of table, Win 0
Auto-populate form field 3
Text in a numeric field 3
Access newbie needs steer 2

Top