Prev: Does anyone else pronounce ODBC as OddBock?
Next: Browse FTP Directory
From: Luft on 10 Jun 2010 12:53
Using Access 2007, I need to modify a row source property of a combo
box via the query builder so that the "Or" row of one of the fields
refers to the value of one of the columns in a list box on the main
form. The list box on the main form has a bound column but it isn't
the one I need.

Here is a more detailed description:

I have a helpdesk application that has a form that is used to enter/
display progress records for a helpdesk incident. On this form there
is a combo box that allows the help provider to choose his/her name
when entering a new progress record. When a user selects a progress
record from a main list this form is displayed with the detail record
and the combo box is populated with the help provider's name.

All was well for years. But as time went on and staff left and new
staff hired we decided that we needed to add an active flag to the
list of providers so that only employees that were still working for
us would be displayed.

The problem is that because this form is used to display old records
as well as enter new records the existing progress records where the
provider at the time was no longer active does not show the inactive
provider's name.

I wrote this application ten years ago. What would have been easy
then seems challenging to me now. I know what I want to do but I
don't remember how to do it.

I think I need to refer to the listbox column something like
<listbox>.Column(col, row) but I don't if anything like this is
possible through the query builder and I don't remember how to the row
number of the selected row in the main form's listbox.
 | 
Pages: 1
Prev: Does anyone else pronounce ODBC as OddBock?
Next: Browse FTP Directory