>Thanks for your suggestion. Sorry for the delay in replying - I've just come back to this problem.
>In debug I can see what you say is so - that the controlsource's have already been assigned by the time I get to the Form Init event.
>
>But, since it's the Form Init event that receives the parameter from the menu indicating the table for the form to use, how can I know which table to open when in the Form Load?
>
>Perplexed
>Martyn
Martyn, you're right about the order of events. You will need to send the table name to the form in another way.
1. If you use an application object, add a property to hold the tablename.
2. Use a public variable
3. Do not assign the Control Source of any textbox until the INIT, then after you USE the correct table, assign the correct field to the controlsource of each control.
Hope this gives you some ideas.
Barbara