Recent content by Edski

Same problem I have the exact same problem. Except I use Dim myChart As Object Set myChart = Me!myChart.Object.Application.Chart to reference the chart object in the form. In any case the chart just doesn't seem to have the most recent values - just like you. It's driving me bonkers!

Legend Hi Tim, If you hit the F2 function key while in the VBA editor you will see a list of classes, properties and objects and the members of each object. You will see that the 'Legend' Class has no 'Text' or 'Caption' property. It does however have a LegendEntries property (or method). I...

Yes, I have no trouble with sorting dates either. It must be something specific in your code or database design.

You haven't defined stlinkcriteria for starters. How does the code know which ProjectNumber to assign?

Me.OrderBy = "AnotherColumnNameb ASC" Me.OrderBy = "AnotherColumnNameb DESC" You could have a toggle button or change the caption each time the button is pressed.

Actually the cursor does not necessarily have to leave the changed field to show you the result. You can use the OnChange Event for either the 'Qty' or the 'Amount' fields and show a message box with Nz(Amount,0) * Qty.Text (putting an error trap in case Qty is Null). Whenever you change one...

I noticed this problem once before too, and I'd be interested in the solution ! I discovered that some References are only added when you 'add' a control that 'uses' it. Eg. adding a Microsoft Forms 2.0 control to a form will automatically add the reference to the DLL - without telling you! No...

The OnOpen Event will only work for the record that appears when you first open the form. It will not work if you scroll through the records. Also, you'll need to add a bit more coding (see below) in case there is data in the combo boxes and you want to change the second (or third) combo box...

Why not add the following to the AfterUpdate Event for the field: field = "R3 - " & field