edit works, add doesn't

[Guest]

I have a form which pulls values from a table directly. I want to be able to
add a new row and also edit the values of any fields in an existing row (in a
separate form). The edit function works perfectly:

DoCmd.OpenForm "frm_TRA_AddBase", , , "[anBaseID]=" & Me.Text38.Value,
acFormEdit, , True

the add command, does not:
DoCmd.OpenForm "frm_TRA_AddBase", , , , acFormAdd

Can someone please help me out here, as I am sure someone knows the mistake
I am making? (unless you need more info on the form that adds/edits to the
table)

 

[Scott McDaniel]

I have a form which pulls values from a table directly. I want to be able to
add a new row and also edit the values of any fields in an existing row (in a
separate form). The edit function works perfectly:

DoCmd.OpenForm "frm_TRA_AddBase", , , "[anBaseID]=" & Me.Text38.Value,
acFormEdit, , True

the add command, does not:

What do you mean by it "does not" work? Does the form open?

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[OTWarrior via AccessMonster.com]

it does not show an number in the "anBaseID" field on the form, it just
shows as blank. Plus it doesnt
add a new row to the table, which similar code has done elsewhere.

I have a form which pulls values from a table directly. I want to be able to
add a new row and also edit the values of any fields in an existing row (in a

[quoted text clipped - 4 lines]

the add command, does not:

What do you mean by it "does not" work? Does the form open?

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com