Passing a Parameter in a query to update Linked Table

[jmccon]

I have a linked table tblHome which is stored in a Sql Server DB and I want to create a form with 3 fields in it i.e. fieldA, fieldB, and FieldC in it and a button.


I want to add values to fields fieldA and fieldB and fieldC and when I click the button I want the value in fieldA to update any records in the linked table tblHome which contains the values in fields fieldB and FieldC.

Anyone know how to do this?

[NTC]

1. Make a query of tblHome using fields B & C as criteria - so that the result is always the correct record set - name that something like 'BCrecords'

2. then you make an Update query using BCrecords as 1 table in query design - joined to the tblHome by the unique ID field; and putting field A from the form as the value to update into the table

of course your permission to write to SQL Server is presumed......

[pbaldy]

Simplest is probably to create an update query that uses the 3 textboxes in the appropriate places, then execute that query from your button (OpenQuery).

[pbaldy]

Oops, typed too slowly. It can be done in a single query I believe.

[jmccon]

Thanks for your reply pbaldy.
Have you any examples of how to do this query that you say?

[pbaldy]

UPDATE TableName
SET FieldA = <FormReference>
WHERE FieldB = <FormReference> AND FieldC = <FormReference>