How do I report or update only the record a user is in?

[mrushton]

I have a fairly simple database, currently the user adds details then presses a 'Save and Send" button which emails a reports all records where [Reported]=No. Except if other users are entering info it picks up all the new entries etc...so I want to know how to set only the value for THAT record, and report only THAT record. Can some of you talented people out there help me with something that is probably really easy to do...but not in my knowledge base.

Thanks

existing:
update [AM - New Supplier Information] set [Reported]=True

 

[KenReay]

Hi

Extend the criteria of your report (currently I assume [Reported] = false) to [Reported] = false AND PrimeKey = Me.PrimeKey, where PrimeKey is the unique identifier of the record (and is a control on your form)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[mrushton]

Thanks, this makes sense. I currently report with the simple query:

Field: Reported
Table: AM Add Offer
Criteria: No

To update the record, to replace my exisiting "Run SQL" code
what will this change to? The contol on the first form is [AM Company Name]

Thanks heaps

 

[KenReay]

Something like:

DoCmd.RunSQL "UPDATE .... WHERE REported = False AND [AM Company Name] = '" & Me.[AM Company Name] & "';"

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK