By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,079 Members | 1,338 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,079 IT Pros & Developers. It's quick & easy.

Me Statment Help

P: n/a
Hi
I hope I can explain this all ok

I have on a form "frmCustomers" a command button on the [event procedure]
I have
Dim x
x = fHandleFile("mailto:" & Me!ContactEMail, WIN_NORMAL)

The record source on the form comes from a table called Customers
Which works fine

BUT what I want to do is make another form where the record source comes from a table
callled tblEmail

So if I make a command button with the [event procedure]

Dim x
x = fHandleFile("mailto:" & Me!ContactEMail, WIN_NORMAL)
IT will go and look in the table "Customers" for some reason

What I want is

go and look in the "tblEmail table and get the info from the "ContactEMail" field
How do I alter this please
As always, any and all help is greatly appreciated.

Thank you in advance.

John
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Me!" refers to the currently active object (form or report). You can't
directly reference a table the way you want. You'll either need to us one of
the domain aggregate functions such as DLOOKUP, or some code that does DAO
or ADO code to read the information. Hint: DLOOKUP is far easier. Take a
look at it in Help.

Larry Linson
Microsoft Access MVP

<ho**@hope.com> wrote in message
news:4f********************************@4ax.com...
Hi
I hope I can explain this all ok

I have on a form "frmCustomers" a command button on the [event procedure]
I have
Dim x
x = fHandleFile("mailto:" & Me!ContactEMail, WIN_NORMAL)

The record source on the form comes from a table called Customers
Which works fine

BUT what I want to do is make another form where the record source comes from a table callled tblEmail

So if I make a command button with the [event procedure]

Dim x
x = fHandleFile("mailto:" & Me!ContactEMail, WIN_NORMAL)
IT will go and look in the table "Customers" for some reason

What I want is

go and look in the "tblEmail table and get the info from the "ContactEMail" field

How do I alter this please
As always, any and all help is greatly appreciated.

Thank you in advance.

John

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.