By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,395 Members | 1,412 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,395 IT Pros & Developers. It's quick & easy.

How to add/edit/delete from one form (was Access Form!!!)

P: 1
Please can someone tell me if I can use a single Ms Access form for add/modify/delete as well as QUERY BASED ON A PARTICULAR FIELD?
I am able to use the form to query on a particular field which then retrieves the data and allows user to update the fields. But if I want to add new record on this same screen how can I make the form do it? Early reply shall be apprciated...thnx...
Aug 12 '07 #1
Share this Question
Share on Google+
2 Replies

P: 2
from what you describe, just me.dataentry=true would work.
If you are not sure how to add vba code and events ... here is a quick and dirty way to make it work

-- Add a command button,
-- a wizard will appear
-- choose "Record Operations" and choose "Add Record"
-- complete the wizard with a name for your button, such as "ADD"

Let me know if I misunderstood your problem.
Aug 12 '07 #2

Expert 2.5K+
P: 3,532
Please remember to provide a meaningful Title for any threads you start! This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions. It is difficult for the experts to answer questions when there is not enough details provided to understand the problem.

Please take the time to read the Posting Guidelines, paying particular attention to Give a clear title to your question.

While setting DataEntry to true will allow new records to be added, that's all it will allow. It won't allow for the editing, deleting or even viewing of any records previously entered! Assumiing that the form is based on a table or an updatable query, you need to, in Form Design View goto the form's Properties Box - Data and set these properties:

Allow Edits Yes
Allow Deletions Yes
Allow Additions Yes
Data Entry

Try this and see what happens.

Welcome to TheScripts!

Linq ;0)>
Aug 12 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.