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

[pahuja]

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...

[ezderek]

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.
D.

[missinglinq]

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.

http://www.thescripts.com/forum/thread559246.html

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 No


Try this and see what happens.

Welcome to TheScripts!

Linq ;0)>