Listbox to assign transactions to billing statement

[arnelgp]

After Exit For:

End If

Also move:

forms!mainform.dirty=false

Before:

forms!mainform.Recalc


Cj, it is for op.

 

[CJ_London]

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]

After Exit For:

End If

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

 

[arnelgp]

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

 

[yeasir01]

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

Iv attach some photos for review.

 

[arnelgp]

Is txt_id bound to statement id. It should.

 

[yeasir01]

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]

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

 

[yeasir01]

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]

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]

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.