Inserting into Sharepoint Lookup Field

[MarkCX]

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 - I'm new to using SharePoint.

If anyone can point me in the right direction, I would very much appreciate it.

Thanks
Mark

 

[boblarson]

Are you inserting the ID information for that field or the description part? That is the issue with lookups like that. You have to insert the correct data which is the value not seen and not the data that is seen.

 

[MarkCX]

Thanks for the prompt reply.

I'm trying to insert the Primary Key value from table A into the Lookup Field on table B if that's what you mean.

I'm not getting any errors either, just a blank field.
Just to make sure, I tried inserting a value I knew wasn't in table A, and got an error saying "...there is no matching error", which is what I would expect!

 

[boblarson]

I haven't done a lot with SharePoint and, especially, not in the past 5 years. So hopefully someone with more SharePoint experience will chime in.

 

[MarkCX]

Thanks for trying. I'm new to SharePoint and it does some things in a weird way!