Form opening in add mode

[paulhenley]

I have a form with subform that was launched in two modes (add & edit). I used a separate form to enter search criteria that then opened the main form with items that matched the data enterd in the search form. All worked very well, but all of a sudden my main form now only opens in add mode with a new record. I have tried all different methods to open my main form with all records, but each fail. I do not believe that I have changed any coding, but I have obviously done something really stupid.

Please can anyone help me identify where I look to make the form open with all records instead of just a new record.

Many thanks

 

[David R]

Couple of thoughts...

Check the form which opens your form (if I read your question correctly). The Macro or Event Procedure that opens your form may have the Data Made set to Add, or acFormAdd for a code module. Also check the Form's properties to see if it is set to Data Entry: Yes. It should be No to see old records.

 

[paulhenley]

David,

Thank you for your help. The Data Entry was set to Yes, I changed it to No and all worked OK. The strange thing is that I know for definite that I did not change this to Yes (well not directly anyway - I don't know if the system has done it automatically somehow) I could not even open the form directly in anything but add mode.
I'm sure I had this problem before and I went to a backup copy to get around it.
Is it somethiong that I am doing that changes this value?

Many thanks once again.

Paul.