Form and 2 Tables

  • Thread starter Thread starter eschlep via AccessMonster.com
  • Start date Start date
E

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
 
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.
 
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
 
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.
 
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.


Duane said:
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
Click to expand...
[quoted text clipped - 12 lines]
Click to expand...
 
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

eschlep via AccessMonster.com said:
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.


Duane said:
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
Click to expand...
[quoted text clipped - 12 lines]
bounded to another table. I cant use subforms or relationships.
Thanks
Click to expand...
Click to expand...
Click to expand...
 
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.
 
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.
 
Back
Top