I have an invoice form where user can add/edit invoices. Form opens in add mode (invoice number is autonumber). I have a command button that allows user to search on invoice which then redisplays form with selected invoice number displayed (FindRecord used). This only works if the form was in inquiry mode....displaying an invoice. If in add mode (autonumber in invoice number field), I get error that find / replace will not work. Is there a different approach that I can take?
Add Mode is only for adding records. You can't see past records in Add Mode. however from your command button you can open same form in add mode or edit mode with proper parameters in docmd.openform method. I need some more info for futher advice.