I wonder if I'll ever get this...

[elektrik]

So, I've been studying VB and I'm trying to do a simple update from one record to another-Ex. if I select "Elektrik" in one field, I want the email address in the next field I have to automatically select "elektrik@mindless.com" so I don't have to enter it. I figure out the right syntax (I originally was using If statements).

If anyone could take time to help me, I would greatly appreciate it.

Thanks in advanced!

 

[Jack Cowley]

You could use Dlookup in the After Update event of your first field to populate the second field. Your code might look something like this:

Me![SecondFieldName] = DLookup("","MyTable", "[Name]='"&Me![FirstFieldName]&"'")

 

[elektrik]

Heh heh. I'm not even sure what that statement means, but I'll try it (ok, so I'm REALLY new to VB =])

Thanks Alot for responding-I appreciate it!

Regards,

Jerrold Horgan