Unable to Add or Edit a new Record

[b77ar]

If any one can help cuzz i couldn't solve it
i can't add or edit a new record
thanks for help

 

[ted.martin]

Looks like you have the Navigation Buttons set to None

 

[missinglinq]

Any idea where this and similar subs came from?

Private Sub ÇáÃíÏÇÚ_ÊÓãíÉ_Click()

My guess is you got a corrupt form! I'd try getting rid of these subs then importing everything into a blank db.

 

[boblarson]

Also, in your form's recordset (QUR) you have this:
TRASEED: (select(sum([IN])-sum([OUT])) from [INOUT] where newtable.[NUM]>=[NUM] and NewTable.[Account_no]= [Account_no] )

and that will automatically make your recordset non-updatable. You can't have calculated fields in a form's recordset if you want to be able to update it.

 

[RuralGuy]

You can't have calculated fields in a form's recordset if you want to be able to update it.

I'll bet you meant to say aggregate function rather than calculated fields.

 

[boblarson]

yep, language will trip me up every time.

 

[RuralGuy]

Mornin' Bob. You are a posting demon.