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

Filter on current record in a form upon selecting a check box

P: 2
Hi Everyone,

I have a database that has a checkbox to indicate that the record is not complete and no longer active.

When I click the check box I would like it to filter on the ID number to limit to that record and then output this to an email that will be sent to selected members that the actions are complete.

I have tried a where statement but I must be doing it wrong as I still output all the records.

I have never done VB before so I have created the filter in a macro.

I hope I have expainted it ok, any help would be appreciated.
Feb 3 '08 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 374
Can you post what you've created so far so we can see where you're possible mistake as at?

Thanks,

Joe P.
Feb 4 '08 #2

P: 2
Hi,

I have a ID on the form which is an autonumber

I have a checkbox called complete and in the Afterupdate property I have a macro 'Email RMA

The macro is structured as follows:

1st line Apply Filter - this has a where I don't know what to type I took out the code I put in because it didnt' work it was something lke "ID"=Me![ID]""


2nd line SendObject - this section of the macro works ok
Feb 4 '08 #3

NeoPa
Expert Mod 15k+
P: 31,186
Can you post what you've created so far so we can see where you're possible mistake as at?

Thanks,

Joe P.
Joe,

I've sent you a PM (Private Message).
To access your PMs simply click on the blue link at the top of any of your pages where it says 1 PMs. Obviously the number may vary, but you get the idea.
Feb 8 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.