Combo Box Histroical Information

I have a form which has a record source of Personstbl. The Pesonstbl holds
the ID of a barrister which is populated using a combo box on the form. The
combo box is based on a lookup table of barristers names and filtered to only
show names of barristers available to use (check box on lookup table -
available/not available) and the control source for the combo box is the ID
off the Personstbl. If I select a barrister the ID is recorded on the
Personstbl and next time I open the form for that record the ID is shown. If
I then make the barrister not available he no longer appears as an option in
the combo box which is correct but the problem is that the combo box for any
record that has that barrister is blank. The info is still on the Personstbl
it just will not show on the form in the combo box as the control source -
any help will be appreciated as how to get it to show.
--
Kaz

Hi,


It sounds like a design problem. I assume you have either:

a table where you have ALL the barristers, available or not; and a table
for ONLY the barristers which are available


either

a table with ALL barristers, in which one of the columns' table has a flag
check or unchecked as availability can be tell from it.



Then bind the combo box row source to the table with only the available
barristers (first scenario) or with a where clause (second scenario) which
will look for the required flag value.


and for your form, probably based on a join, in the first scenario, uses the
first table, or, in the second scenario, do not uses any condition on the
availability flag.



Doing so, your combo box will display only available barristers, but the
form will continue to display correctly previously entered records.



Hoping it may help,
Vanderghast, Access MVP


"Kaz G" wrote in message
...
I have a form which has a record source of Personstbl. The Pesonstbl holds
the ID of a barrister which is populated using a combo box on the form.
The
combo box is based on a lookup table of barristers names and filtered to
only
show names of barristers available to use (check box on lookup table -
available/not available) and the control source for the combo box is the
ID
off the Personstbl. If I select a barrister the ID is recorded on the
Personstbl and next time I open the form for that record the ID is shown.
If
I then make the barrister not available he no longer appears as an option
in
the combo box which is correct but the problem is that the combo box for
any
record that has that barrister is blank. The info is still on the
Personstbl
it just will not show on the form in the combo box as the control source -
any help will be appreciated as how to get it to show.
--
Kaz