Help with Resync Command Property

[hblabonte]

I have an updatable snapshot form in Access, which pulls data from two tables. I have the unique table property set to allow updates to the main table. The second table is purely a lookup table.

When I update fields(from the main table) on the form, I'd like the appropriate lookup values to also change. I believe the resync command property would allow this, but I haven't been successful with it. How do I get all of the data displayed to update? I'd appreciate any input.

TblMachine is the primary table. It's key is the NvSerialNumber and NvModelNumber. The field "MachType" is what will not update on the form as I make changes.

Here is the query behind the form:

SELECT dbo.TblMachine.NvSerialNumber,
dbo.TblMachine.NvModelNumber,
dbo.TblMachine.NvMaristTag, dbo.TblMachine.NcTypeCode,
dbo.TblMachine.CreationDate, dbo.TblMachine.ModifyDate,
dbo.TblMachineType.NvType,
dbo.tblMachine.NcTypeCode + ': ' + dbo.tblmachinetype.NvType AS MachType
FROM dbo.TblMachine RIGHT JOIN
dbo.TblMachineType ON dbo.TblMachine.NcTypeCode = dbo.TblMachineType.NcTypeCode

Here is the query associated with the resync command property:

SELECT dbo.TblMachine.NvSerialNumber,
dbo.TblMachine.NvModelNumber,
dbo.TblMachine.NvMaristTag, dbo.TblMachine.NcTypeCode,
dbo.TblMachine.CreationDate, dbo.TblMachine.ModifyDate,
dbo.TblMachineType.NvType,
dbo.tblMachine.NcTypeCode + ': ' + dbo.tblmachinetype.NvType AS MachType
FROM dbo.TblMachine RIGHT JOIN
dbo.TblMachineType ON
dbo.TblMachine.NcTypeCode = dbo.TblMachineType.NcTypeCode
WHERE dbo.TblMachine.NvSerialNumber = ? AND dbo.TblMachine.NvModelNumber = ?

Thanks in advance,
H. Barnes