Recent content by RedWingsFan44

For the purposes of this project, only 1 user will be accessing the application. I put the checkbox in the line items table because I could not get a dynamic number of checkboxes to show up depending on how many line items are generated in the subform. I will look into the ADO recordset method...

If I base the listbox on a query instead of value list doesnt that mean I will not be able to use the additem/removeitem code? On another note, the only reason I was using the longhand syntax is because it is much easier for me to use the Ctrl+Space to bring up the autofill list. Sorry I am...

Thanks Galaxiom, I will switch syntax throughout the database. Your post kind of went over my head... I will do some research on fabricated ADO recordsets, but could someone guide me as to what query the listbox would need to be based on? Should it be the same query that the form is based...

Update: I have think I am headed in the right direction, but still need some help to figure this out... I am getting a runtime error '7777' with this code, it says that I have used the ListIndex property incorrectly: If InvoiceY_N.Value = True Then InvLineTotal = ([PO Line Item Total])...

I noticed that the listindex method partly works but only when a line is highlighted in the listbox and then i click on the checkbox to uncheck it. The problem is that no matter which line item I uncheck in the subform, the selected line in the listbox gets deleted even if the two dont match...

First off thanks for replying! JHB: I tryed using this: 'If InvoiceY_N.Value = False Then Form_frmInvoiceNew.ListLineitemsold.RemoveItem Index:=Form_frmInvoiceNew.ListLineitemsold.ListIndex But I am now getting an runtime error 5: Invalid procedure call or argument. I tryed checking the...

I'm using Access 2010 and have a form that is basically the last step in generating a report (which will be a printable invoice). I am facing major problems when it comes to removing line items that the user may have accidentally clicked. I have a checkbox field embedded in the table...