InfoPath Dev

  Update...if my client goes to the document library, he can open existing forms. If I give him a link to an existing form, he cannot open it.

I've done what was mentioned and also mimic'd the template that you just posted. Sadly this does not solve the problem. I've attached an image with the exact rules that was given in the template but it will still query the entire SharePoint List for all the computer types. So John will show all the computer types regardless of who the ...

I'm attaching the list form I used for testing this prior to suggesting it to you. Save the form locally. Right click and select design. Take a look at the form load rules. You won't be able to preview, of course, since it is connected to my Office 365 site.

So in your form load rule, you should set the main data source query user name field to the main data source data user name field, then run the query. When you open an item, the data fields will have the user name for the item.

In the new Item view, it is a blank form which is correct. In the Edit AND View item View, it is showing all the computer types regardless of username. This is most likely because on form load, I query the main data connection. It is not specific to the username that I view or edit the item from.

Sorry, I'm still not understanding. I think you are saying in the Edit view the form loads correctly but in the regular View Item view it does not?

Hilary, I've attached screenshots with the details. As you can see from the list John does not have a value of 634, but it still shows up when I view an item. I'm assuming this is because when I query for data in the form load, it picks up all of this type of data and fills it in, i don't know how to make a condition where if the ...

Maybe attach some more screenshots that show your current rules & results.

Thank you! :) Sadly, another issue came up where if I view items, it does not query based on username it'll group all the computers together. For example, If I view a row where the username is John, it'll also populate all the other users computers but the username in the form load will be John. :( And I thought I solved ...

I knew you could figure it out. :)