Re: UpdateQuery only on the record specified by a form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Is there a unique field in the record the user is updating? for
example AutoNumber, Cust # , so forth. You can use this criteria
directly in your query an should see the result you are looking for.
Meaning placing the form value in the query criteria, and updating the
appropriate fields that need updated based off what was selected on the
form. If there is nothing unique that can identify one common record
from another then it will update all of the like records.

.

Relevant Pages

  • Re: Did I dream it?
    ... Everything you wrote may be true but you can't extend that to saying "Updating is required" FREE BMD is not "required" to do anything. ... If they've decided to give higher priority to the vast majority of users rather than matching "the criteria that it should match" that is their choice. ... You claimed that you were somehow representing the interests of the volunteers who have freely contributed tens of thousands of hours to the project. ... You have every right to speak on your own behalf but you have no right to speak on theirs. ...
    (soc.genealogy.britain)
  • performing an unusual record search
    ... i need to do a record search in a form but there are a few twists. ... there is no unique field to any of these records ... searching the table for all records that match those criteria. ... let a user select a record), then closing the popups and displaying the ...
    (comp.databases.ms-access)
  • Re: update the %complete according to actual date
    ... purposes of updating. ... like tasks based upon specific criteria and then just re-apply the group ... Is there any way that i can make a selection of different tasks to be ...
    (microsoft.public.project)
  • Re: crosstab query
    ... or enter the following as the criteria ... In the SQL statement that would be ... particular account number by updating a combo box on a form. ... have in the crosstab query is as follows: ...
    (microsoft.public.access.queries)
  • SQL Update query
    ... We are having problems while updating one table based on certain criteria. ... In our scenario, there are 3 tables i.e EIM_ACCOUNT, S_ORG_EXT, S_EVT_ACT. ... Column definition of above table ...
    (microsoft.public.sqlserver.mseq)