Listbox to assign transactions to billing statement (1 Viewer)

arnelgp · Apr 18, 2018

After Exit For:

End If

Also move:

forms!mainform.dirty=false

Before:

forms!mainform.Recalc

Cj, it is for op.

CJ_London · Apr 18, 2018

It is better not to use Update query on selecting/deselecting from listbox

if that is referring to my suggestion, I was suggesting using a subform, not a listbox

yeasir01 · Apr 18, 2018

arnelgp said:
After Exit For:

End If

Now im getting runtime error '2448'
You cant assign a value to this object

arnelgp · Apr 18, 2018

Make sure to put statement_id on the form and on its Property-Visible is No.

yeasir01 · Apr 18, 2018

arnelgp said:
Make sure to put statement_id on the form and on its Property-Visible is No.

Iv attach some photos for review.

arnelgp · Apr 18, 2018

Is txt_id bound to statement id. It should.

yeasir01 · Apr 18, 2018

arnelgp said:
Is txt_id bound to statement id. It should.

Yes, as you can see in the debug mode it's pulling the value 18 which is correct.

arnelgp · Apr 18, 2018

Is it possible fir yiu to zip your db and uoload to better understand why it wont allow the update.

yeasir01 · Apr 18, 2018

arnelgp said:
Is it possible fir yiu to zip your db and uoload to better understand why it wont allow the update.

The two forms are clients billing & clients billing popup.

arnelgp · Apr 18, 2018

Id is autonumber so we cannot assign value to it. Also on the listbox statement_id is always null. It will take time ti fix this.

yeasir01 · Apr 19, 2018

arnelgp said:
Id is autonumber so we cannot assign value to it. Also on the listbox statement_id is always null. It will take time ti fix this.

I think you got it wrong?? I need to pass the value to the list box Statement_id field.