Inserting into Sharepoint Lookup Field (1 Viewer)

M

MarkCX

New member

Local time

Today, 21:07

Joined

Jul 20, 2012

Messages

4

• Jul 20, 2012

• #1

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

Smeghead

Local time

Today, 13:07

Joined

Jan 12, 2001

Messages

32,059

• Jul 20, 2012

• #2

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.

 

M

MarkCX

New member

Local time

Today, 21:07

Joined

Jul 20, 2012

Messages

4

• Jul 20, 2012

• #3

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

Smeghead

Local time

Today, 13:07

Joined

Jan 12, 2001

Messages

32,059

• Jul 20, 2012

• #4

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.

 

M

MarkCX

New member

Local time

Today, 21:07

Joined

Jul 20, 2012

Messages

4

• Jul 20, 2012

• #5

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