Update Query against current record not entire table

[gtiller]

Hi all,

I have a really simple query, which populates four fields in one of my tables:

UPDATE [Personnel Records]
SET
[Personnel Records].[Full Name] = [First Name] & " " & [Last Name],
[Personnel Records].Initials = Left([First Name],1) & Left([Last Name],1),


[Personnel Records].[E-mail Address] = [First Name] & "." & [Last Name] & "@DEMO",
[Personnel Records].Username = "DEMO\" & [Last Name] & Left([First Name],1);

The query is initiated when I hit the save record button (a macro)
How do I update just the current record instead of the entire table?

I don't want to calculate these values within the table itself (although I am aware that you can do this with Access 2010), as eventually all of my tables will be moved to SQL, and the forms and queries will be packaged.

Thanks!

[RuralGuy]

You need to add a WHERE clause that specifies the PrimaryKey of the Current record.

[gtiller]

Aha, great.

Never used where before.

Is the syntax something like this:

WHERE [Personnel Records].[recordID] = forms![myformname]![recordID]

Cheers

[RuralGuy]

Let the Query wizard help you with the syntax. I'm a long way from an expery on SQL.