I hope someone can help me with this and I am about to tear my hair out.
I have a app that will have a SSTab on it. On the first tab I have some text boxes linked to a database. One of the boxes holds a number 1, 2, 3 etc. These refer to a record and all the boxes populate ok. On tab 2 I have copies of three of the boxes including the Number text box, and a Rich Text File box. What I need is help wioth the code that as the number in the text box (the numbered one) changes from say 1 to 2 the rich text box unloads 1.rtf and opens 2.rtf.
Does that make sense?
I tried adapting a read write text file and putting it in the navigation buttons of the datbase (move next etc.) but it doesn't seem to work.
Can you help? Also can I get the Rich Text box to clear and be emt=pty ready when I click add record and then write a file. Example I add record and it autonumbers on the Access Database to 3 and the rich text file 3.rtf is created too?
Thanks for any help in advance