a few fields in the record are lookups to other tables. In this case, I have one field which is processor_speed. I cannot poke 400 into it by updating the record. If I open Access and view the form, I can select 400 from the drop down list.

this is the lookup info:
Row Source: SELECT Processor.Processor FROM Processor;
(which is a list procesor speeds)

but the table I have my inventory is [PC Inventory Main TBL] (and where I'm doing record updating)

the recordset command from my script is(doesn't work): $Recordset.Fields("ProcessorType").Value = "$CPUsp"

The other fields which are just text update fine.

Any help is appreciated...