Continuous Form and 'independent' listboxes

  • Thread starter Thread starter Craig Buchanan
  • Start date Start date
C

Craig Buchanan

I would like to add a listbox to my continuous form, where the rowsource
changes by each row in the form. Is this possible? Seems like changing the
rowsource affects *all* rows in the form.

Help appreciated.

Craig Buchanan
 
That is correct, this is rather difficult to do with a listbox and a
continuous form. With a *combo* there is a way you can get the *effect* of
having a rowsource which is dependant on other data in the row current
record. To create this effect with a combo create another textbox control,
include the display column of the combo in the Recordsource query of the
form (join the foreign table and drag in the column). Position and size the
new textbox so that you can place it directly over the combo box allowing
only the down-arrow portion of the combo to show.

Create a GotFocus event for the textbox that only does a SetFocus to the
combo.

This will create the effect that you are wanting - the correct display value
will always show even though the value itself might not be fit the criteria
that is in effect based on the current record.

Here's a KB Article that explains the problem
ACC2000: Combo Box in Continuous Form Shows Incorrect Data
http://support.microsoft.com/default.aspx?scid=kb;en-us;208866

Here's a link to my sample database that offers several different
alternatives for displaying this type of data including the technique
described above:

http://www.daiglenet.com/msaccess.htm
 
Back
Top