Search results

First, here's my code that doesn't work: Private Sub Report_Open(Cancel As Integer) Dim Args() As String Dim ControlName As String Dim Property As String Dim Value As String Dim ThisArg() As String If Not IsNull(Me.OpenArgs) Then Args = Split(Me.OpenArgs...

Wow, don't I feel stupid. Thanks for your help, but the problem is my own mistake. Turns out the WhereCondition for the OpenReport contained an incorrectly-typed field name. It should read as follows... strWhereCondition = "SalesOrder.CustomerRef_ListID = '" & Me.cboCustomer.Value & "'" & "...

Nope, not on a subform. Are there some debugging hints someone can give? I've checked and tried a lot of things for this to no avail. -Sparky

Customer.ListID is a unique string. Example: "2EC0000-1137506644" SalesOrder.Customer_ListID relates the sales orders back to a customer. Changing from using the Value property to the Column(n) property doesn't seem to make a difference in whether there's a dialog box displayed or not. -Sparky

Me again... :) I have a form with a combobox at the top. This shows the customer name and has a hidden customer ID field. There is also a date picker control. Both of these affect a listbox control that shows records associated with sales order line details. The two comboboxes filter the...

Well, I have it working the way that was suggested by Dev. Again, much thanks. It's been a long time since I've done any VB programming, and it's the little things that are tripping me up. I've been given a screenshot of another person's Access database, and asked to replicate the...

Dev, From one Canuck to another, thanks for the help! You've gotten me about 75% of the way, and I'm hoping you or someone else can give me just a little bit more of a push here. The query is a bit more complicated than I'm used to working with. The list box update is happening after it...

Greetings all... I've been given the task of creating an Access database form - probably something that's seen a lot on this forum. I have considerable programming experience with other languages - C, Pascal, Java, etc, etc... but little with VB and Access. What I'm trying to accomplish is to...