Run time error 3464

[whojstall11]

Im getting a run time error when i try to pull infomation from my Order table to my Hardware form. can anybody help body

Private Sub PO_Number_AfterUpdate()
 
 
Me.[OS] = DLookup("[OS]", "[Order]", "[PO Number]='" & Me.[PO Number] & "'")
Me.[Memory] = DLookup("Memory]", "[Order]", "[PO Number]='" & Me.[PO Number] & "'")
Me.[Processor] = DLookup("[Processor]", "[Order]", "[PO Number]='" & Me.[PO Number] & "'")
Me.[Speed] = DLookup("[Speed]", "[Order]", "[PO Number]='" & Me.[PO Number] & "'")
Me.[Processor Type] = DLookup("[Processor Type]", "[Order]", "[PO Number]='" & Me.[PO Number] & "'")
Me.[Total Disk Space] = DLookup("[Total Disk Space]", "[Order]", "[PO Number]='" & Me.[PO Number] & "'")
 
End Sub

 

[bob fitz]

If [PO Number] is numeric try:
Me.[OS] = DLookup("[OS]", "[Order]", "[PO Number]=" & Me.[PO Number])

 

[whojstall11]

Nevermind i fix it!!! it looks something like this. Thanks

Private Sub PO_Number_AfterUpdate()
 
 
Me.[OS] = DLookup("[OS]", "[Order]", "[PO Number]= Form![PO Number] ")
Me.[Memory] = DLookup("Memory]", "[Order]", "[PO Number]= Form![PO Number] ")
Me.[Processor] = DLookup("[Processor]", "[Order]", "[PO Number]= Form![PO Number] ")
Me.[Speed] = DLookup("[Speed]", "[Order]", "[PO Number]= Form![PO Number] ")
Me.[Processor Type] = DLookup("[Processor Type]", "[Order]", "[PO Number]= Form![PO Number] ")
Me.[Total Disk Space] = DLookup("[Total Disk Space]", "[Order]", "[PO Number]= Form![PO Number] ")
 
End Sub