I have a simple database that has one table, one query, one form, one report, and one switchboard (form).
The query looks at all fields on the table and is the source for the form. The form adds new records to the table. The table populates the report. My primary key are dates. I have a Find button on the form that looks by a date.
The issue I am having is that when I click the Find button (created with the Command Wizard) for the form, it comes up with the message "The command or action 'Find' isn't available now."
I decided to go back to an older version of the DB I saved when the Find button was still working. I noticed that when I changed the form's Data Entry to Yes the Find button would then return the message above. If I changed the Data Entry back to No the Find button would work as expected.
I need the Data Entry to be set to Yes so that it comes up blank when a user wants to input data, but I need the Find button to work in case they need to go back and edit an older record. Is there a simple way to fix this? OR a different manner to have the form come up blank, or a different method [using macros] to "find" a record?
Thanks for the help.
P.S.
On my current version of the DB, changing the form's Data Entry back to No still has it display the error message above.