Peter,
>On the REQUERY step, I modified it slightly due to the fields location to read...
>
>lcFirmId=Thisform.pageframe1.page1.cbFirm.List(Thisform.pageframe1.page1.cbFirm.ListItem,2)
>Requery(PartnerFirm)
>
>and I added this to the cbFirm interactivechange method...
>
>Thisform.pageframe1.page1.clientpartnerid.requery()
>
This will be correct once you put quotes around the alias name in the requery() function call as in Requery("PartnerFirm").>If this is all correct, the next question is what should I set the properties for in the clientpartnerid combo? Especially the ROWSOURCETYPE, ROWSOURCE & BOUNDTO. Also, right now the controlsource for this is a field in the CLIENT table called client.partnerid... that should be fine, correct?
>
Set RowSourceType to alias and rowsource to the alias name of the view PartnerFirm. >Finally, do I need to call the REQUERY when the database - Nexts or Prevs because the cbFirm changes accordingly?
No, because the requery method repopulates the list for the combo, it has nothing to do with the combo's value changing. If your combo has a controlsource it will change its value automatically every time it is refreshed to match the value in the controlsource.