>>>>I am new to VFP and am attempting to write a timekeeping program. The requirement is to have all entered records for the pay period on the screen at once (so I use a grid on a form) and to be able to input data directly into the cells(right word?) or to be able to press a trigger of some sort (I used double click) to display only valid values from a reference table (free table) or a table from another database for each cell(?) I can get this to work for the first 5 cells(?), but when I add the double click method to the 6th cell and run the form, I get the message "Too many files open". To confuse me futher, when I click on help, which is supposed to (as I understand it) give me help re: my error message. I get a completely different error. This error says something about I am trying to pass something invalid between methods. Is there a better way to achieve what I am trying to do or Iam I on the path I want to follow and need a little help to get past this roadblock. If I
>>>need
>>>>a little help, can you point me in the right direction?
>>>
>>>
>>>How are you opening your files? When you are testing and get this error, have you tried suspending the program and looking at the View Window to see exactly how many files ARE open? Keeping in mind that for every .DBF that is open you are using a file handle for it, its .CDX (if existing) and one for the memo file (.FPT), if existing.
>>>
>>>What are the file handles set to in the config.sys? for the network? what Windows is it running on?
>>
>>I am opening two of my files in the form's init property. The other two I am opening in the init property for the cell. And I have suspended the program to figure a way to see that but could figure out how, I thought there ought to be a way.
>>
>>Files in config.sys are set to 100 and we are running Windows 95
>
>OK. When you suspend the program and get the Command Window, type "Acti Wind View". This will open the View window and allow you to see what files are open.
>
>My suspicion is that you are opening the files with "USE filename IN 0 AGAIN" or with a created alias and are hitting the init method more than once. To watch the code, after suspending, type "ACTI WIND TRACE" and step through the code and SEE where it's going and what line of code is triggering the "TOO MANY FILES..."

I tried ACTI WIND VIEW and there are two open files. I opened the debug window when I get the message and I am getting the message when I do my third form on "do form".

Thanks for your suggestions.