unbound textbox into different table

[Guest]

Hi all,

I have form that works fine based on an established table. But we would
like to add a text box for which the end user could enter some info but have
that become a record in an entirely different & new table (for reasons I
won't bother you with...)

I put a new text box on the form but the only control source options in its
properties are of course the primary table the form is designed for...

Not sure how to "link" the new text box data in this case to the new table
record/field - or should I be thinking combobox? - - - welcome advice thnx

 

[Allen Browne]

Place the text box in a subform, which has the other table as its
RecordSource.