We have sucessfully created a look up from a SharePoint list in a List box
using MS InfoPath 2003 SP 2.
When first built, it displayed the correct listing of data. However, when we
added data to the SharePoint list, it does not replect in the InfoPath form.
The onlt results are from the original list.
2 questions:
1.) What do I have to do to make it look at the current values of the
SharePoint list when a new form is opened?
2.) How can I make them display in alphabetical order?
Thanks for any help you can provide. We appreciate it.
Kalyan G Reddy MVP (GGK Tech) - 23 Aug 2007 16:18 GMT
Hello Mike,
have you read this link already
http://www.infopathdev.com/blogs/matt/archive/2006/02/02/Add-SharePoint-List-Ite
ms-with-InfoPath.aspx

Signature
Kalyan G Reddy - INFOPATH MVP 2007
http://www.ggktech.com
> We have sucessfully created a look up from a SharePoint list in a List box
> using MS InfoPath 2003 SP 2.
[quoted text clipped - 7 lines]
>
> Thanks for any help you can provide. We appreciate it.
K.Ramana Reddy(GGK Tech) - 23 Aug 2007 16:20 GMT
Hi,
It should reflect changes made in list in infopathmlist box. I checked your
scenario it is worked for me.
Can you give more details like : what are the values are originally and what
values are added afterwards.
Did you check the check box automatically retrieve when the form is opened
when you are taking connection to share point list.

Signature
k.Ramana Reddy
http://www.GGKtech.com
> We have sucessfully created a look up from a SharePoint list in a List box
> using MS InfoPath 2003 SP 2.
[quoted text clipped - 7 lines]
>
> Thanks for any help you can provide. We appreciate it.
Mike - 23 Aug 2007 17:58 GMT
It is a WSS v2 Custom list. It is single line straight text field. I do
remember chcking the box that automatically retrieves the data when the form
is opened.
Is there anyway to check that after the data connection is made?
BTW - Thanks for the response.
> Hi,
>
[quoted text clipped - 16 lines]
> >
> > Thanks for any help you can provide. We appreciate it.
K.Ramana Reddy(GGK Tech) - 24 Aug 2007 04:40 GMT
Hi,
You can check that check box by modifying the existining data connection.

Signature
k.Ramana Reddy
http://www.GGKtech.com
> It is a WSS v2 Custom list. It is single line straight text field. I do
> remember chcking the box that automatically retrieves the data when the form
[quoted text clipped - 23 lines]
> > >
> > > Thanks for any help you can provide. We appreciate it.