Help with an update query and macro plz...

[Nitrous]

I have a table with multiple data entries in, and what im trying to do is get a set of update queries run via a macro to update a single field rather than the entire column of data. At the moment it updates the field for every data entry and i need it to update it for just the active data entry, the one i want to change. Please help. Thanks

 

[Rich]

Reference the forms keyID field in the query criteria

 

[Nitrous]

how do you mean?I have a 4 digit unique ID, how do i reference it?

 

[Rich]

In the criteria cell of the key field add something like
Forms!YourFormName!YourKeyFied, the code builder will create the correct references for you