Recent testing has shown a couple of querky things when attempting to setup an Infopath form to recieve data from a SharePoint 2007 list. It took a little working out but the following apply;

  1. SharePoint list items formatted as ‘Multiple lines of text’ with the column setting set to either Rich text or Enhanced Rich text, are not available in Infopath when pulled through a data connection. I only resolved this by setting the item column to Plain text.
  2. Data pulled through the data connection is related only to the SharePoint list default view. I was pulling information across from a calendar view and only a month’s worth of data was available. You’ll have to set the default view to an ‘All items’ view to pull across all the data.