Crazy subform problem

[missthing]

I am biulding a database with quite a few subforms but now I have a wierd problem.

I am building a form that displays upcoming IT courses. so I have sumbforms for word, excel, outlook... you get the picture.

All the subforms work well except the outlook subform. When I create the subform with a wizard. When I go into form view mode to check, the form displays Outlook courses. When I save the form, the outlook subform then changes itself to Excel!


When I open the excel form and the outlook forms independently (not as subforms) the work fine and the data sources (queries are correct)

I've tried deleting the subform over and over again but everytime I hit the save button, The outlook form reverts to Excel.

I've gone as far as checking if there is any code behind the main form that makes this happen, but nothing.

Can anyone heelp>? this is driving me crazy!

 

[M8KWR]

I have had something similar, but not as wierd as yours. But i solved my issue by looking in the autocorrect options, everytime a typed something it always changed it, that got me confused, and this solved it.

I just hope this may work for you, let me know if it does or doesn't....

 

[missthing]

thanks for the reply, unfortunately that didnt work. I got around the problem but creating a command button and opening the form separately from there.

Is there a limit to how many subforms you can have on a form? the outlook one would have been the seventh. the Help menu doesn't say anything about subform limita though.