Append New Record Via A Form?

[Faraz Ahmed Qureshi]

Have never used Append Queries and therefore lack the knowledge of the same.
I have a sample table "Students" with fields like:
1. ID (AutoNumber)
2. Name (Text)
3. Nationality (Lookup with Row Source being Selection from the table
"Countries")
4. Date of Birth (Date)

Now I want to create a form which would not be showing the records already
in the database but simply present a one page layout with the 4 controls for
each of the fields and a button which upon being clicked shall add the data
entered in the same to the Table "Students".

Please c if any of u xperts can provide me with help especially by a sample
file, if possible, emailed to faraz DOT qureshi AT nibpk DOT com

 

[Marshall Barton]

Have never used Append Queries and therefore lack the knowledge of the same.
I have a sample table "Students" with fields like:
1. ID (AutoNumber)
2. Name (Text)
3. Nationality (Lookup with Row Source being Selection from the table
"Countries")
4. Date of Birth (Date)

Now I want to create a form which would not be showing the records already
in the database but simply present a one page layout with the 4 controls for
each of the fields and a button which upon being clicked shall add the data
entered in the same to the Table "Students".

Why go to all that trouble? Just use a form bound to the
table and open it with the data mpde argument set to
acFormAdd

That form can usually be the same form you use to view
and/or edit existing entries in the table.