[Last Call] Learn how to a build a cloud-first strategyRegister Now


How let form close if opened by mistake

Posted on 2011-04-21
Medium Priority
Last Modified: 2012-06-22
I have aform that when opened autopopulates a few required fields but if the user opened it by mistake and does not want to create a new entry he/she gets a message indicating that a particular field has not been entered.  Is there a way to sidestep this message and let the user close the form?
Question by:SteveL13
1 Comment
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 35443202
hmm, provide a Cancel button to undo the forms

private sub btnCancel_click()


docmd.close acform, me.name

end sub

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question