I know this is a silly question, but it is the end of the day and my brain has fused together again!!
I have a form which does every thing I want, now I have just started to use the form to search and group data, which works as expected. But I have found a glitch:
I have a field that brings in data from the correct location for dislpy, I have set it to a drop down list so that when I do a search I can drop the list down and select the value I want to group the records by and this works great. Although when I am not searching it is possible to drop the list down and change the data to something else, which updates the actual record with the new value.
I have looked at the relationship and settings and can't figure out how to stop data input but allow it to have a drop down list for searches.