Inserting records into a table through a form

[ocp&mcsd]

Hi all,
Really, I am very happy to be a member in this great forum with those great members....

I have a form with two text boxes and one button "Submit". And also, I have a table with two columns. How can I insert records into this table through that form by clicking that button "Submit"....
I think it is simple, but I am very beginner in Access....
See the attached file....

Thank u and sorry 4 bothering u....

 

[ansentry]

Just make the form bound to the table (via the query).

 

[ocp&mcsd]

Thank you Mr. John
But, I want the user each time to find the two text boxes empty when openning the form.
Also, I want him after filling the two text boxes and clicking the button, the entered record to be fiiled in the table.
Also, the user should not be able to see other records when openning that form.

Really, I am so sorry for bothering you Mr. John.
Thanks & Regards

 

[xxyy]

Hi there!

If you think you can try this:

http://www.access-programmers.co.uk/forums/showthread.php?t=103630

BR

SzCs

 

[ocp&mcsd]

That is exactly what I need....
Thank you very much Mr. XXYY

 

[ansentry]

What you need is a form that is set to Data Entry = Yes.
Have a look at the new sample. I have set the form to Data Entry "Yes" and that mean when the form opens is opens to a new record and you can't see "old" records. After your user enters the data he click the >* and that takes him to a new record.

Try it, if this is what you want then this is easier that using unbound controls.

To set the form to data entry read this from help:

Prevent a data-entry form or page from showing existing records

Hide All
Prevent a form from showing existing records

Open the form in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.).
Double-click the form selector (form selector: The box where the rulers meet, in the upper-left corner of a form in Design view. Use the box to perform form-level operations, such as selecting the form.) to open the form's property sheet.
Do one of the following:
If you don't want the form to display existing records, set the DataEntry property to Yes.

If you want the form to open with all records showing, set the DataEntry property to No.

Really, I am so sorry for bothering you Mr. John.

Your are no bother, post back if you require further assistance.

 

[ocp&mcsd]

Your are no bother, post back if you require further assistance.

Thank you very much Mr. John