Search results

Hi, Using VBA, I'm trying to insert new data into a SharePoint Table. All the data inserts into every field just fine, except for a lookup field which remains obstinately blank. I've also tried an append query and this does the same thing too. I'm hoping this is something obvious I've missed...