As usual I am not sure that I am posting this in the right section therefor I have also posted it in other sections... sorry.
My question is... I am using a Where clause on the OpenForm command and I want to be able to create a new record if there are no query results. Right now it shows me one blank record. How can I trap the event to add a new record instead?
Thanks in advance for any help you can provide.
My question is... I am using a Where clause on the OpenForm command and I want to be able to create a new record if there are no query results. Right now it shows me one blank record. How can I trap the event to add a new record instead?
Thanks in advance for any help you can provide.