Cecil

OK, so you do actually live near Devore, where the Renaiassance Pleasure faire is coming to its' closing weekend, so that would account for your lapse into period English. (I work there, even though I really am English - wanna come and play, let me know.)

If your tables are related prior to the forms execution, your fields should track properly; if you are setting the relations within the form then they may be stuck on the ControSource that existed when set. Try a thisform.refresh() after you move your main pointer. (You can set this in the InteractiveChange method of any object related to the main table that will have a unique value)

I am assuming that all objects are related to the tables with their ControlSource, if not, please explain further.

Anon

Steve Hanlan
aka Sir Edward Tilbey, Queen's Court, Southern Renaissance Faire