Form and 2 Tables

[eschlep via AccessMonster.com]

I have a form and i have textboxes that link to tables. How do i make it so
that i can have some textboxes bounded to one table, and other textboxes
bounded to another table. I cant use subforms or relationships.
Thanks

 

[Duane Hookom]

Perhaps you should explain "I cant use subforms or relationships." Don't you
know how or are you bound by some set of rules that are unreasonable?

You can use an unbound form and use code to update records from multiple
tables.

 

[eschlep via AccessMonster.com]

Can i have a bound form and then use code on on a couple text boxes in order
to bound them to a different table

 

[Duane Hookom]

Sure. You would need to use ado or dao code to retrieve and post values. I'm
hesitant to provide the actual code since I would use a query or subform.

 

[eschlep via AccessMonster.com]

It would be really helpful if you would post that code. The way the form is
setup i cannot use subforms for these perticular textboxes. I just have 3
textboxes that need to be linked to a different table.

Sure. You would need to use ado or dao code to retrieve and post values. I'm
hesitant to provide the actual code since I would use a query or subform.

Can i have a bound form and then use code on on a couple text boxes in
order

[quoted text clipped - 12 lines]

 

[Duane Hookom]

You already stated you couldn't use subforms. You never stated "why".

We don't know anything about your tables or fields or criteria for selecting
the record to display or what would trigger a retrieval or what would
trigger a save.

--
Duane Hookom
MS Access MVP

It would be really helpful if you would post that code. The way the form
is
setup i cannot use subforms for these perticular textboxes. I just have 3
textboxes that need to be linked to a different table.

Sure. You would need to use ado or dao code to retrieve and post values.
I'm
hesitant to provide the actual code since I would use a query or subform.

Can i have a bound form and then use code on on a couple text boxes in
order

[quoted text clipped - 12 lines]

bounded to another table. I cant use subforms or relationships.
Thanks

 

[eschlep via AccessMonster.com]

I am making a form for other users on the netowork to use, the table that all
the data is based off of will get changed often so the table will get
replaced removing all relationships. The text box that i need to link to a
different table are paired with the records in the table. I tried using
unbound text boxes but since i use continous forms the same thing is
displayed in the text box for every record. I figured that if i could link
the text boxes to a different table each record could display a different
cell in a different table making each textbox unique to each record.

 

[Duane Hookom]

You never mentioned before that the form was continuous. Code will not work
with a continuous form as you have found. You would need to use bound fields
from your form's record source. You don't have to define relationships in
order to use subforms or queries.