Search results

Trying to figure out how t delete this post because the tables are not viewing correctly. Also, I solved the issue by adding a secondary sort after the PODate sort.

I have a query that only has 4 fields: SalesOrder, SalesOrderID, FabSO, and PODate. When it is sorted by PODate it sorts as shown below: qryUniqueSOFromtblTempFabReq SalesOrderSalesOrderIDFabSOPODate SDR0493443FAB0225/13/2025 SDR0503444FAB0225/13/2025 SDR0513447FAB0225/15/2025...

Attached is the db. frmSalesOrderEntryCabs is the parent form and is a list of Sales Orders. sfrmSOShipInfo is a subform that was only added to allow the user a familiar way of editing ship info. sfrmLineItemsDE is a subform and contains the code causing the error. It lists line items for...

good question. I currently use conditional formatting to color the cboFinishID control. Originally, I thought there would only be a dozen or so colors. I was just advised that the list would grow to 90 colors! I believe with conditional formatting you can only have about 50 sets or rules...

Interesting thought! Both the parent form and subform are set to allow additions. One of the error instances happens when I move to the blank/new record on the parent form. That's why I put in the Len(Me.cboFinishID & "") < 1 test to see if it is a null value. But the same error occurs on...

I get the 2424 error: What's odd is that the error only appears when viewing specific parent records. The code works when I open the subform directly and for most of the parent records. I will try making a db that has the relevant forms and tables copied so I can easily upload.

Got it. I had revised that line to: FIN = Me.cboFinishID But it still doesn't work. What's odd to me is that the subform errors out to 2424 only when specific parent records are pulled up and there is no reference to any parent form controls or data in this subform code. cboFinishID is a...

So I tried the below revisions based on the link but I still get the 2450 error. And it only happens when I move to certain records on the parent form (including the blank/add new record) But I haven't figured out any meaningful differences between the parent form records that have the subform...

I have the below code in a subform. The code works when I open the subform directly by itself. But it gives me a 2424 or 2450 error when I open the parent form. I've tried a bunch of different ways of referencing the control (cboFinishID) but I keep getting the error message that Access...