Continuous Form Calculations

[carpediem79]

Ok...I have a continuous form. Part of the records which get displayed is a field containing and ID number. From that ID number, the name and another number are calculated and put into 2 other text boxes.

I have it working using a vba function, however if TextFieldA contains the ID, For Records 1 it could be ID 20, but for record 2, it could be ID 10.

When the info is displayed, I see it pop up with the name of the person from record one for ALL of the records. Then, the name of record 2 pop's up for all of the records becauise it is different.

This thing is driving me bonkers!

 

[Remou]

That is the way continuous forms work. Unbound controls display the same data for all records. Have you considered a query?

 

[carpediem79]

Yea, I was just trying to avoid having to store more data if I could. No biggie though. I can calculate the name using DLookup and will just make a new field storing the other value.

It works good now

THanks for that info though Rem, good to know.

 

[Remou]

It is somewhat against the rules to store calculations in a table. You can do most calculations in queries.