Recent content by ptodd

Oops!Sorry about that. The data type is "Number"

Fixed with two decimal points

I'm getting a strange occurance when importing orders from a SQL server table. For a little background, I'm using SQL Server 15 and MS Access 365. I am bringing orders into SQL from our website with an API. From there I'm running a series of stored procedures to import them into our Access front...

Has this issue been resolved? I started getting this error last week.

ShipToAddressTablesubformRetail is the name of the subform used for retail customers Ship_To_Address_Table_subform is the name of the subform used for wholesale customers

My bad, scrolling was the wrong word to use. I meant clicking on the navigation buttons to go forward or backward. Yes. The retail checkbox is in the "OrderHeader" table that is the record source for the main form. The main form is single

When the form is initially opened, it works fine, But when scrolling through data, if the ShipToAddressTablesubformRetail is visible, then you go to the next record and this record does not have Retail checked, it still displays the retail subform vs Ship_To_Address_Table_subform.Visible

I have a form "Order Summary"(main form) and two sub forms. I would like to display one or the other sub from based on a check box (retail) on the main form. This is "on current" of form. Me.ShipToAddressTablesubformRetail.Visible = Me.Retail Me.Ship_To_Address_Table_subform.Visible = Not...