Hi Jeff.

>Okay. I'm hollering!!!! (As we say here in Georgia)

Type CREATE VIEW in the command window to bring up the view designer. Add the table cdcHIV and select the field you want in the view on the fields tab.

Since you have only one table in this case, it is easy. After you have your fields, go to the filter tab and select your id field fron the drop down list of fields. Now, in the example column, type ?lcID.

Under the update criteria tab, select your updateable and key fields and don't forget to check that obvious little check box that says send sql updates.

Now you can use this view in the DE of your form just as you would use any other table. Just set NoDataOnLoad to true in the property sheet and whenever you want to populate the view, you set your variable lcID = and issue the command REQUERY('lv_cdcHIV') assuming that this is what you named your view.

Couldn't be easier. Right?

Marcia