Recent content by billwagnon

I put a delete button on my form to delete records from two tables - the "project" from the _Project table and the project items from the _ProjectItems table. This appears to work, but when the user selects another project from the listbox this error comes up: "The data has been changed...

I'm having a similar problem. Is a zipped sample database available?

On a form I have these items: 1. Customer selector. 2. Customer's project selector. 3. Textbox for project name. 4. Subform for project details. When I select the customer I want to automatically select the last project. The code I am using work except for the automatic selection. If I take...

okay, I got it I just changed the query to pull all the goodies for the second column as a concatenated string, with the id column being 0 width

that shows the name in the combobox, but I want to show everything in the drop down I am planning to code on the click to change column widths.

progress! thanks for all your help, I'm actually getting somewhere! I've been banging my head on this a couple days and progress is exciting! couple of problems - once I select a project, I can still select from the customer combobox, and if I change it, the customer on the project is...

here is my click event: Dim sCriteria As String Dim bFound As Boolean 'On Error Resume Next sCriteria = "Customer='" & cboCustomer & "'" bFound = (DCount("Customer", "_Project", sCriteria) = 1) If bFound Then Filter = sCriteria FilterOn = True...

do I need a special query for the 2nd listbox? I am using the click event for the first listbox. I also don't know whether to set the 2nd listbox rowsource in code, or in the properties of the listbox. Thanks for your help!:)

I am new to Access and need help! I've done a lot of VB work but the bound nature of Access forms has me stymied. I have two tables - "Projects" and "ProjectItems". Projects contains the customer id, the project name, and a description field. ProjectItems contains all of the items for the...