Linking a control to a field in a table.

[Woof]

Hi.

A form is bound to a large data table. All is working well.

On the form I have a tab control and one of the tabs is called 'options'. Inside options I have a textbox which will hold a numeric value, (this is a user setting for a point over which actions will change.) This I wish to store in a seperate table from the one the form is bound to, I am calling it "tblIni", in an integer field.

If I go into the properties of the textbox under ControlSource I can set it to =tblIni!ProlificSetting using the wizard. However when out of design view I have the error #Name? showing in the text box and I can't enter a value in it. I know #Name? means it can't find the source but it was seen by the wizard and hasn't been deleted. Hmm, I'd better make sure theres a record in there...

I'm doing something simple wrong, but what please?

Thanks.

 

[Woof]

Solved.

I don't know if this is the 'right' way but I added a sub form to the options tab and bount it to the ini table. If there's a better way let me know please!