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

[scotribs]

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.

[PianoMan64]

Can you post what you've created so far so we can see where you're possible mistake as at?

Thanks,

Joe P.

[scotribs]

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

[NeoPa]

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.