I All, First i apologyze for my

[tanolalano]

I All,

First i apologyze for my bad english.

I have 3 list box in a subform. The 3 list box have for record source each one a table. This 3 table have a reletionship. Selecting the first listbox limit the row of second listbox, and so on for third list box. The value of the three listbox is stored in one other table.
This work fine.
When i move to new record and select onother value of listbox, the previous value selected in listbox change as i select in the new record. I know that the value stored in the controlsource is correct (is numeric), but it's necessary for me view what i put in the previous record.
Any Suggestion?

Thanks in advance
I need to see each row

 

[JeremyNYC]

It sounds like you need to hang onto the values of the previously viewed record, and have them available for the newly current record. If that's the case, you might try calling some code in oh the On Current and the After Update events that sets some invisible, unbound controls on the form to the values you want.

I've never done this before, and I'm sure others have, so you may get better answers from others. But it seems simple enough.

Hope this is helpful.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[tanolalano]

Thanks Jeremy, i need something like this.

Can anyone help me?

Thanks again