Cetin:

I want to let you know that my combos are working pefectly. Thank you for the help. I am no longer getting an error message that says "record out of range" and when I close and re-open the form, the data is visible and stored correctly. I couldn't ask for much more!

It was a great learning experience to place the SQL statement for my Pview into the combo.init(). I will certainly implement this proceedure in the future.

Cetin. Everything is working perfect, however, I want to truly understand what you helped my create. I don't just want to place the code in the correct position, have it work, and not fully understand.


What is the true advantage of placing the SQL statement of the pview into the combo.init() and setting the variable lcSQL, versus the way I had it set up previously (which was no code in combo.init_? Previously, I placed the pview into the combo.rowsource and called the pview that way to supply the data to my combos.

Why is it better to have the code placed in the .init? (at least as far as pviews are concerned)

Thank you again Cetin for the instruction

Jason