Records not visible in form

[Alan_78]

Hi

I am new to access (this is my first attempt at creating a database) and am using Access2010 and windows 7.

I have created a database to capture information for a research project on young stroke. The DB contains multiple tables and forms linked via a single form 'patients' using buttons. The main form also includes buttons for save, save and new record and save and close DB. The problem is is that periodically data that I have entered is not visible or searchable within the main form even though the record is saved to the table. I have tried several save options (buttons, ribbon etc) but I can't seem to find the reason that the data is not saved to the form. Does anyone have any ideas? I have attached a blank DB for confidentiality reasons.

Thanks for the help.

 

[rodmc]

Hi

I am new to access (this is my first attempt at creating a database) and am using Access2010 and windows 7.

I have created a database to capture information for a research project on young stroke. The DB contains multiple tables and forms linked via a single form 'patients' using buttons. The main form also includes buttons for save, save and new record and save and close DB. The problem is is that periodically data that I have entered is not visible or searchable within the main form even though the record is saved to the table. I have tried several save options (buttons, ribbon etc) but I can't seem to find the reason that the data is not saved to the form. Does anyone have any ideas? I have attached a blank DB for confidentiality reasons.

Thanks for the help.

Check your form properties and ensure that its not in data entry mode

 

[MStef]

In properties "Data Entry" put NO.

 

[Alan_78]

Thanks for the suggestions. Data entry is set to No. Other properties: Recordset type dynaset, Fetch defaults = yes, Filter = blank, Filter on Load = no, Order by = blank, Order by on load = blank, wait for post processing = No, allow additions = yes, Allow deletions = yes, Allow edits = yes, Allow filters = yes, Record Locks = No locks.

It seems to be a periodic problem and picks out some records. I can see some of the records but not the complete set even though they were all entered through the main form.