I've got it working. In the end I just refresh the query providing the
lookup information after the new record is added to the lookup table.

Part of my previous problem was I was also using AfterInsert instead after
Post.

I think I have it all correct now. I'll write the tutorial and then we'll
see how much of it is wrong <g>

Mal