Combo Box Historical Infomation

[Guest]

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.

 

[Roger Carlson]

This is a sticky problem. The way I have solved it is to have two separate
forms (or sometimes have two different views of the same form). One allows
you to view historical information ONLY and the combo box information is NOT
filtered for current values. The other form allow you to only add new
records, and the combo box on this one IS filtered for current values.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

This must be a real stumper for all you "GREAT" access programmers out there
as I have received no responce as to how to overcome this dilemer. Could
this be the ultimate programmers nightmare - the dreaded combo box!!

 

[James A. Fortune]

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.

First, read:

http://groups.google.com/group/comp.databases.ms-access/browse_frm/thread/de6c1b04461c2fc4

to see if the concept addressed there is similar. If not, I'll take a
look at the problem you have.

BTW, I did spend time thinking about that problem like I suggested and
found it profitable. I don't write lots of bound forms so I never
encountered that particular problem before. It was a great question.

James A. Fortune
(e-mail address removed)