Using an unbound form in Access populated with a recordset

[Guest_imported]

Hello

I'm having trouble at the moment trying to link an unbound form to a recordset with Access. I can't work my head round this, I populate the recordset with a the following query

SELECT
dbo_tblContractQuality.*,
dbo_tbl_stafflist.ChristianName,
dbo_tbl_stafflist.Surname

FROM dbo_tbl_stafflist

RIGHT JOIN dbo_tblContractQuality

ON dbo_tbl_stafflist.Agency_Ref =
dbo_tblContractQuality.AgencyRef;

All I want is when someone enters the AgencyRef field for it to update the form with ChristianName and Surname of the member of staff. I'm getting error messages telling me I can't update linked tables but I don't want to update the linked table I only want show the values. Can someone point me in the right direction.

Thanks

Mike

 

[ghubbell]

Hi Mike,
Is the dbo_tbl_stafflist table linked? Do you have permissions to read/update it's data if you go directly to it?
Gord
ghubbell@total.net