Help!

[AccessNewb]

O.K.
I have a form that has text boxes for fields from one table. I enter data into those text boxes and my table is updated. NOW, I need to place another text box on this form, but the field is from another table. How do I accomplish this?

I can do this by recreating this form and placing the text box to the other table in at this time. But I do not want to redo All of my forms.

Please help, need quick
Thanks and nice boards.

 

[wh00t]

why are the 2 fields in seperate tables? Are these tables linked in any way?

you could try making a query and basing the form on the query instead of the table.

 

[AccessNewb]

No they are two different fields. Field A and Field B.
Field B is in another table and I need a text box for this field in a form that contaions fields for a different table.

 

[AccessNewb]

I quess another way to look at it is: How do I add a field from another table to the Field List of a particular form?

 

[Tay]

As wh00t said, a query should do the job, providing that the tables are linked.

 

[wh00t]

when you have a form based on a table, there are 2 ways to add to a field on a second table like you want

1) the field in the second table is linked to a field in the first (usually of same name and type).
2) create a query that includes the fields from both tables, and base the form on this query.

 

[AccessNewb]

Thanks guys,
I went back and fixed my SQL statement to include the field from the other table.

Thanks again