I have a textbox on my form and the forms record source is table1. I have a second textbox on the same form, but i would like to make its record source table2. What is the property i need to change to make it write to table2. Thankyou
Textbox assocication with table
- Thread starter beatleman
- Start date
ColinEssex
Old registered user
- Local time
- Today, 19:26
- Joined
- Feb 22, 2002
- Messages
- 9,314
The recordsource for a form should never be a table, it should be a query.
If you have the relationships right, you can then draw fields from more than one table.
Or you can explore the possibility of using a sub-form.
Col
If you have the relationships right, you can then draw fields from more than one table.
Or you can explore the possibility of using a sub-form.
Col
not too sure what you are after
however if you look at the zip file attached I think this might be what you are after - (Not the flash form the other one)
this uses a combo box to populate a field on your table ??
I might of got what you are doing wrong
however if you look at the zip file attached I think this might be what you are after - (Not the flash form the other one)
this uses a combo box to populate a field on your table ??
I might of got what you are doing wrong
re:
Gary, its not what i am trying to do. Let me explain
When you create a form from a wizzard you can set its record source in properties, so i can have multiple text boxes on my form and it will write to the assigned table. i.e table1.
However, in my instance, i have a textbox on the same form that i want to associate with table2, and not the default table 1. So the question is, what property or code do i need to make this data write to the table2?
Gary, its not what i am trying to do. Let me explain
When you create a form from a wizzard you can set its record source in properties, so i can have multiple text boxes on my form and it will write to the assigned table. i.e table1.
However, in my instance, i have a textbox on the same form that i want to associate with table2, and not the default table 1. So the question is, what property or code do i need to make this data write to the table2?
OK
Right - will it be 1 entry or could you have more than 1 entry on this 2nd table
for example
1 client ( on table 1)
with lots of products on table 2
ie
mr Smith
has lots of products
(I am in insurance so I still with this )
he has
car insurance
house insurance
usiness insureance
holiday insuraance
all of the insurances will be in table 2
and I have this set up as a contonious.. form
if you look at ther attached zip folder I have added another dbase in it that allows
1 client or record with mutliply child records
if it is purely 1 item on the table then the question is why ??
Right - will it be 1 entry or could you have more than 1 entry on this 2nd table
for example
1 client ( on table 1)
with lots of products on table 2
ie
mr Smith
has lots of products
(I am in insurance so I still with this )
he has
car insurance
house insurance
usiness insureance
holiday insuraance
all of the insurances will be in table 2
and I have this set up as a contonious.. form
if you look at ther attached zip folder I have added another dbase in it that allows
1 client or record with mutliply child records
if it is purely 1 item on the table then the question is why ??
re:
Gary thankyou, but if you dont mind, can you do me an example of a form with two textboxes only. The form will be dataentry only.
Textbox1 named Product will write to Product in table1
Textbox2 named Type will write to Type in table2
Yes i will have more textboxes in my form, i just want to see hows it done, in code, when you want to write to another table. Cheers!
Gary thankyou, but if you dont mind, can you do me an example of a form with two textboxes only. The form will be dataentry only.
Textbox1 named Product will write to Product in table1
Textbox2 named Type will write to Type in table2
Yes i will have more textboxes in my form, i just want to see hows it done, in code, when you want to write to another table. Cheers!
