arnelgp ..forever waiting... waiting for jellybean! Local time Today, 14:05 Joined May 7, 2009 Messages 20,354 Apr 18, 2018 #21 After Exit For: End If Also move: forms!mainform.dirty=false Before: forms!mainform.Recalc Cj, it is for op. Last edited: Apr 18, 2018
After Exit For: End If Also move: forms!mainform.dirty=false Before: forms!mainform.Recalc Cj, it is for op.
C CJ_London Super Moderator Staff member Local time Today, 07:05 Joined Feb 19, 2013 Messages 17,556 Apr 18, 2018 #22 It is better not to use Update query on selecting/deselecting from listbox Click to expand... if that is referring to my suggestion, I was suggesting using a subform, not a listbox
It is better not to use Update query on selecting/deselecting from listbox Click to expand... if that is referring to my suggestion, I was suggesting using a subform, not a listbox
Y yeasir01 Registered User. Local time Yesterday, 23:05 Joined Mar 26, 2018 Messages 67 Apr 18, 2018 #23 arnelgp said: After Exit For: End If Click to expand... Now im getting runtime error '2448' You cant assign a value to this object
arnelgp said: After Exit For: End If Click to expand... Now im getting runtime error '2448' You cant assign a value to this object
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 14:05 Joined May 7, 2009 Messages 20,354 Apr 18, 2018 #24 Make sure to put statement_id on the form and on its Property-Visible is No.
Y yeasir01 Registered User. Local time Yesterday, 23:05 Joined Mar 26, 2018 Messages 67 Apr 18, 2018 #25 arnelgp said: Make sure to put statement_id on the form and on its Property-Visible is No. Click to expand... Iv attach some photos for review. Attachments pic1.png 31.9 KB · Views: 57 pic2.png 49.8 KB · Views: 66 pic3.png 49.3 KB · Views: 55
arnelgp said: Make sure to put statement_id on the form and on its Property-Visible is No. Click to expand... Iv attach some photos for review.
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 14:05 Joined May 7, 2009 Messages 20,354 Apr 18, 2018 #26 Is txt_id bound to statement id. It should.
Y yeasir01 Registered User. Local time Yesterday, 23:05 Joined Mar 26, 2018 Messages 67 Apr 18, 2018 #27 arnelgp said: Is txt_id bound to statement id. It should. Click to expand... Yes, as you can see in the debug mode it's pulling the value 18 which is correct.
arnelgp said: Is txt_id bound to statement id. It should. Click to expand... Yes, as you can see in the debug mode it's pulling the value 18 which is correct.
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 14:05 Joined May 7, 2009 Messages 20,354 Apr 18, 2018 #28 Is it possible fir yiu to zip your db and uoload to better understand why it wont allow the update.
Y yeasir01 Registered User. Local time Yesterday, 23:05 Joined Mar 26, 2018 Messages 67 Apr 18, 2018 #29 arnelgp said: Is it possible fir yiu to zip your db and uoload to better understand why it wont allow the update. Click to expand... The two forms are clients billing & clients billing popup. Last edited: 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. Click to expand... The two forms are clients billing & clients billing popup.
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 14:05 Joined May 7, 2009 Messages 20,354 Apr 18, 2018 #30 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.
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.
Y yeasir01 Registered User. Local time Yesterday, 23:05 Joined Mar 26, 2018 Messages 67 Apr 19, 2018 #31 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. Click to expand... I think you got it wrong?? I need to pass the value to the list box Statement_id field.
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. Click to expand... I think you got it wrong?? I need to pass the value to the list box Statement_id field.