Hi,
Hope this is the correct forum to ask this in.
I'm currently building a DB using SharePoint custom lists. I've run into one issue, where a couple of my list fields are people pickers.
When designing my form in Access, it behaves as a dropdown or Textbox and you have to spell the name exactly as it's listed in SP.
Is there a way in Access to make work like a people picker? Where you can just type in the last name and select from the results?
It's been a long time since I've used Access but I thought I've seen this done before.
Thanks!
Hope this is the correct forum to ask this in.
I'm currently building a DB using SharePoint custom lists. I've run into one issue, where a couple of my list fields are people pickers.
When designing my form in Access, it behaves as a dropdown or Textbox and you have to spell the name exactly as it's listed in SP.
Is there a way in Access to make work like a people picker? Where you can just type in the last name and select from the results?
It's been a long time since I've used Access but I thought I've seen this done before.
Thanks!