Continuous Forms

[stevemccauley]

I have a continuous form. On each line I have a textboxA and textboxB. TextboxA is entered manually and I need textboxB to take the amount from the line above in textboxA and enter it in textboxB.

Does this make sense and can it be done?

Example:

ContinuousFrmA

TextboxA TextboxB
Line1 Red n/a
Line2 Blue Red

Thanks,
Steve

 

[Fizzio]

I think a way to do this is to have a hidden textbox on your form in the footer/header and on the after_update event of the 1st textbox, use the event procedure.

me.hiddencontrol = me.textbox1

set the default value of the 2nd textbox to Forms!yourform!hiddencontrol.

I'm sure this will work.

 

[dcx693]

Here's a link to a Microsoft Knowledge Base Article that talks about how to do it in general. Haven't tried it myself.

http://support.microsoft.com/default.aspx?scid=kb;en-us;136127

 

[Fizzio]

dcx693,

that solution works for carrying the same field over to the next record.

I think Steve wants the value in field 1 in record 1 to be carried over to field 2 in record 2, not field 1 in record 2.

 

[Rich]

You could also use the PrevRecVal function

 

[Idjit]

I've used DLookup to do this sort of thing with pretty good success.

http://support.microsoft.com/default.aspx?scid=kb;en-us;101081

 

[stevemccauley]

Thanks for all the ideas, I'm going to try them and let you know what works.

Steve