>Cetin,
>thanks, I only have a lookup table, basically what I do is this -
>
>If I present the user with a choice of ( e.g. solicitors ) in a combo, I create a table with the solicitors name in one field, and a solicitors code in another, I then use this table as a recordsource for a combo and bind the BoundColumn to the ControlSource i.e. the table I want to update, if you think this is a design flaw please let me know
>
>Regards
>
>Pete
No not at all. I just prefer SQL over directly using rowsource. But it depends. Unlike other controls :
-Combo's when event fires "anytime" as you move between items
-Record pointer "moves" in its rowsource. This sometimes is the desired effect where sometimes just cause headaches.
I think the latter is important more when you have to decide the rowsourcetype.
Cetin