need help with subform

  • Thread starter Thread starter eda
  • Start date Start date
E

eda

We have a form and subform showing two tables in a one-to-many
relationship. We often need to change all the records in the sub-form
to the same value. We've been doing this by either repeatedly entering
each value manually into each record (using <ctrl><'>), or by running a
query.

Is there a way to put a text box in the form over each field in the
subform so we can input a value there and change that field for all the
records in that sub-form to that same value? Or is there some other
way to do this that's easier that what we've been doing?
 
AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
George's reply not withstanding, add the universal change text box txtUniv
for this example. Place a button on the form that will be selected after
entry is made in this text box with the following code in the On click event:
Me!txtFirst = Me!txtUniv
Me!txtsecond = Me!Univ
etc.
where txtFirst is the name of one of the text boxes you want to apply the
universal input and txtSecond is the name of another text box, etc.
Hope this helps,
Bob
 
Back
Top