Update text box data to more than one record source

[carpstar]

This is a re-post from original dated 4/13/02, I still need help with this proplem.

Is this possible???
I have text boxes on sub forms that hav/e either text boxes or combo boxes on a main form as their record source. Is there a way to get the data entered in these text boxes to update to a given table even though another text box is the record source, If so could someone explain how to do this.
Any help or feed back on this would be greatly appreciated.
Thanks in advance...

 

[Fizzio]

Set the controlsource of the textbox to the field you want to save it in then on the After_update event of the textbox whose value you want to copy use
Forms!NameofformforNewTextbox!NameofTextbox = Forms!NameofOldForm!OldTextbox or if they are on the same form
me.TextboxNew = Me.TextboxOld.
BUT I have to ask why you want to duplicate the data into 2 separate tables as this should be avoided.

 

[David R]

Funny, that's the same thing Fornatian asked in the original post: http://www.access-programmers.co.uk/ubb/Forum4/HTML/006575.html

You can continue an old posting just by replying to it again carpstar, then you won't be starting from scratch and others will see what answers have been given before.

Did you ever get your data restructured?

David R

 

[carpstar]

David,
No I haven't had a chance to work on it today(re-structuring), hopefully tomorrow if things calm down at work.I'm sure I need to make some of the fields in my staff hours table into separate tables and set relationships(which is why I'm having such problems designing this form)-- I think I can handle that part. But I still don't know the best approach for putting the form together.
Fizzio,
The separate tables were to be temps that would then,using a macro upate/append data to Staff table then delete. I was going this way because I don't know how to solve the date issue( seven date boxes on one form or, a sub form for each one.Each day has to have all the fields for entering each type of hrs(WorkHrs,SickHrs,VacHrs,etc). So I was trying to start with a Mon. textbox where you enter the weeks start date, the Source record is by default Date field on Staff table and date entered updates to that field. But the source record for Tuesday date textbox will be set at "=[Date]+1" (so user does not have to enter it)which now prevents the date inTue. Date textbox from updating to Date field in Staff table. Fizzio I don't want to copy the text from one text box to another. I hope I'm making some sense, if not please just try to point me in the right direction. Like I mentioned before I'm just starting out with this and what started out as a small database project for very small dept. has steam rolled into something the entire org. wants part of.
Any and all assistance is and will always be deeply appreciated.

 

[Fizzio]

Lets Follow the original thread