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...

code:

---

	if $Connection							;Check for connection object	
		$Connection.ConnectionString = $DSN
		$Connection.Open()					;Open connection to database
		$Command.ActiveConnection = $Connection
		$Recordset.CursorType = 3
		$Recordset.LockType = 3
		$Recordset.ActiveCommand = $Command
		$Command.CommandText = $CHECK_SerialNumber		;Check for existing records for the current workstation/user
		$Recordset.Open($Command)
		If $Recordset.RecordCount < 1		$Recordset.AddNew		Endif
		$Recordset.Fields("LastName").Value 		= "$lastname"
		$Recordset.Fields("FirstName").Value 		= "$firstname"
		$Recordset.Fields("NTLogon").Value 		= "@USERID"
		$Recordset.Fields("ComputerName").Value 	= "@WKSTA"
		$Recordset.Fields("Division").Value 		= "$dept"
		$Recordset.Fields("BureauName").Value 		= "BureauName"
		$Recordset.Fields("Building").Value 		= "Area Office 6"
		$Recordset.Fields("RoomNumber").Value 		= " "
		$Recordset.Fields("Location").Value 		= "6 Tampa"
		$Recordset.Fields("AHCATag").Value 		= " "
		$Recordset.Fields("SerialNumber").Value 	= "$SerNo"
		$Recordset.Fields("Manufacturer").Value 	= "$Make"
		$Recordset.Fields("ModelName").Value 		= "$Model"
		$Recordset.Fields("ProcessorType").Value 	= "$CPUsp"
		$Recordset.Fields("Memory").Value 		= "$Memory"
		$Recordset.Fields("Harddrive").Value 		= " "
		$Recordset.Fields("Bios").Value 		= "$biosv"
		$Recordset.Fields("Surplus").Value 		= 0
		$Recordset.Fields("Comments").Value 		= " "
		$Recordset.Update
		$Recordset.Close()
		$Connection.Close()
		$Connection = 0
		$Recordset = 0
		$Command = 0

---

but the $Recordset.Fields("ProcessorType").Value = "$CPUsp" line doesn't work.