Bound Text boxes not working

[nightangel73]

Okay I have a form and I'm creating bound text boxes to input data. I'm doing the correct, the text boxes are bound to the different tables I want the data to be input but then when I run the form I can't input the data because some of the text boxes become like unbound. I go to the design view and don't know what is wrong because the text boxes are properly bound. I re-do the bound text and it fixes for it but then screws up the others. Do I have to do a query and then bound with the query instead of the tables?

[RuralGuy]

You can *only* bind controls on a form to fields in the RecordSource of the form.

[Missinglinq]

...text boxes are bound to the different tables...

Also, if the above is correct, and you have a Form with a RecordSource involving multiple Tables, chances are that the Form is going to be Read-Only.

Entering data for multiple Tables, from a single screen, is usually done with a Main Form and one or more Subforms, with each Form/Subform being Bound to a single Table.

Linq ;0)>