[AccessD] Updating a table

Paul
When you say "selected by the User", how are they selected? How for that
matter are they originally filtered from the main table? What you need
is to use the criteria which filtered them, plus the criteria which
defines "selected by user", in an uopdate query which will update
TheField with the value "bb3". Beyond that we'd need more info to be
more specific.
 
Andy Lacey
http://www.minstersystems.co.uk <http://www.minstersystems.co.uk/>  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Rodgers
Sent: 07 October 2003 14:49
To: AccessD (E-mail)
Subject: [AccessD] Updating a table 


150 records are filtered from a table (tblMyTable) which holds about
1500 records. 120 of them are selected by the User and now I must enter
the phrase "bb3" into a field called "TheField" in the table. 

Is there a way to have a Query (or code) enter this in the correct 120
records, please, gurus?

paul

Paul Rodgers
Online Strategy and e-PR
Summit Media
tel. +44 (0)1788 523307
fax. +44 (0)1788 523306 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031011/a67332ad/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Glacier Bkgrd.jpg
Type: image/jpeg
Size: 2743 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031011/a67332ad/attachment-0001.jpg>