won't allow edit after search

[Minnesota]

I have this set up with text box serach fields. It works great for the search. However, once I have clicked 'search' I can no longer edit the fields I need. What am I missing? How can I make it so I can edit the fields after I search for them?

 

[Scooterbug]

You cant edit because the underlining query ("tblProjectInfo Query" btw...spaces should be avoided at all cost...) has the totals and group by turned on. You cannot edit a record when that is activated.

 

[Minnesota]

Thank you!

I try to avoid spaces, but this is my working document. When it goes final I'll be sure I have a cleaner database. Thanks though.

 

[Scooterbug]

Thank you!

I try to avoid spaces, but this is my working document. When it goes final I'll be sure I have a cleaner database. Thanks though.

Not a problem. Just remember, that when you change the name of a table or query (in order to get rid of say, spaces) then you have to make sure that you go through and change the name in all of your code and such. It's a good idea to get into the practice now, rather than later. It sucks to have to pour through code because of a name change later on