Insert into table

[byulogia@gmail.com]

I am trying to insert information into the table from the form.
My code is:

Currentdb.Execute "INSERT INTO Applications(AppID, FirstName,LastName,DOB,Gender,Province,Institution ") & _
"VALUES(" & Me.AppID & ",'" & Me.FirstName & "','" & Me.LastName & "'_
Me.DOB & "," & Me.cboGender & "','" & Me.cboProvince & "' , "' & Me.cboInstitution & '")

It is not working.

Please someone can able to suggest a solution or give me a correct sample code. I am a new learner.
Thanks

[June7]

Currentdb.Execute "INSERT INTO Applications(AppID, FirstName, LastName, DOB, Gender, Province, Institution") & _
"VALUES(" & Me.AppID & ",'" & Me.FirstName & "','" & Me.LastName & "',#" & _
Me.DOB & "#,'" & Me.cboGender & "','" & Me.cboProvince & "','" & Me.cboInstitution & "'")


Why do you need to use VBA and INSERT to add data? Why not direct data entry to form bound to table?

[byulogia@gmail.com]

Thank June7.
I can use direct entry to form bound to tables. But when I load forms, the data appears in the form, which I dont want it to. I want the form to open without data so I can continue to add data. Any ideas?

[CJ_London]

set the form dataentry property to true

[byulogia@gmail.com]

Ajax
Wow, thats very simple....
Thanks thanks

[June7]

Or leave DataEntry set to No and use VBA to open form to allow new records only. Greater flexibility to use same form for different situations.

DoCmd.OpenForm "your form name", , , , acFormAdd

Either way, all records created in that session will be available for edit until form is closed.

Or use code that moves to new record row immediately when form opens. Users can still navigate existing records.