list view problem

[mheiy]

how can i add to the list view a specific data.. example on my table i want on form load only does who's first name start with R.

[danasegarane]

Take a Look this example

[mheiy]

what if my table is empty and i will add a new record to that table i always got and error

[Hack]

To add the specific data, you must first retrieve it from your database, build a recordset, and then add the recordset to the listview just like you would any old recordset.

What is the query that you are running to return what you want?