Hi Jim,
>In the cboCity combobox set the rowsourcetype to SQL but leave the rosource empty. In the Requery method of cboCity put code like this;
>Then from the when or interactivechange of the cboState simply;
>
>THISFORM.cboCity.Requery()
Two Questions please:
1. Are you sure about putting the code in the WHEN of cboState? At that point cboState hasen't changed, right? Also, wouldn't it be better in the LostFocus than in the InteractiveChange?
2. Do I gather correctly that it is better to use the
.value rather than the control's ControlSource in the WHERE clause of the cboCity RowSource? Can you share the pros/cons of both approaches?
Many thanks,
jmu
Best Regards,
Jim Underwood
Apollo Information Systems, Inc.
Houston, TX