How to edit data in form in bulk

  • Thread starter Thread starter Surinder Kumar Arora ITS GM EAST MTNL Delhi
  • Start date Start date
S

Surinder Kumar Arora ITS GM EAST MTNL Delhi

Dear Sir,
I have a database having large numer of records for booking and clearance of
faults .I add new records by opening the form because I have to fill up
large number of fields in records. But when I have to clear the fault I
have to open each record by ID and then tick mark the check box in cleared
field and write something in compliance field. For such editing in large
number I have to go to ech record and then go to each field and fill up the
value. I want to cut it short by use of macro, or code or by any other
method . will somebody explain how to do it.
regards
arora sk
 
Dear Sir,
Thank you very much for the reply,
I have been able to solve my problem by use of unmatched querry wizard,
regards,
arora sk
Dan Artuso said:
Hi,
You could do this with an Update statement IF:
- you have some way of identifying the records to be updated by using a Where clause
- whatever you put in the compliance field is the same for each record

Is this the case?

--
HTH
Dan Artuso, Access MVP


"Surinder Kumar Arora ITS GM EAST MTNL Delhi" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Back
Top