combo boxes dont show bound data when scroll thru rows..

[Guest]

I have 3 combo boxes on a form bound to columns on form's record source.
Selecting item in 1st combo limits selections in 2nd, and 2nd limits more for
3rd.

It saves row correctly in table based on combo choices, but if I scroll thru
the form's records, the previous rows are showing as empty for the combo
boxes (though the data is in fact in the table)

I'm showing an expression of LastName & Firstname in the 2 combos where
occurring. When I remove the expression, and only show last name, it works
fine.
I'd like to be able to show both names in the combo when scrolling thru the
records though, if thats possible.

thanks!

 

[Roger Carlson]

Try requerying all of the combo boxes in the form's OnCurrent event.

--
--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