<< I have a form with a DB Lookup ListView control on it. >> You probably want to be using a VARIABLE Lookup ListView, not a DB one.
The terminology is a bit confusing. Both of those controls use a database table as the SOURCE of the information which is used to populate the list view. So both of them will DISPLAY data from the database. The difference is in what happens to the value of the row the user selects while looking at the database. In the variable version, this goes into a variable. In the database version, it goes into a database field. I use List Views on almost every form I write, and I can't remember ever using the DBLookupListView. I'm always simply displaying data, letting the user choose and row and then maybe editing or deleting the row based on the primary key value in the variable attached to the list view. If you change to the variable version, remember that the control will not display any data if there is any error in the WHERE or ORDER BY clauses, or if you've forgotten to create and assign a variable to the control. -- Larry
