Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is It Possible To Have A Textbox Pull From One Table And Save In Anoth 1
- Thread starter toddOne
- Start date
-
1
- #2
Well..........I presume that the control source of that text item is set to ur table1...rite... ?? Now u want that when u save the record it should save the value to another table..U have not specified that u want to insert the value or to update the value, so u can use update or insert query behind any event..... anyhow one sneaky way of doing it can be
draw another text box and set its control source to table2 field and set its default value to text box that is linked to table1 field. U can make the 2nd text box invisible and locked so that user might not see it. Although its is simple n maybe stupid but it works for me
Cheers!
Aqif
draw another text box and set its control source to table2 field and set its default value to text box that is linked to table1 field. U can make the 2nd text box invisible and locked so that user might not see it. Although its is simple n maybe stupid but it works for me
Cheers!
Aqif
- Status
Similar threads
