Combo Box Rowsource ADD Data

[sanders720]

I have a combo box that uses a SELECT statement to populate the choices. I would also like to insert a blank choice at the top of the list in addition to the SELECT data. How would I change the following syntax?

Me.[cboInstalled PC Name].RowSource = "SELECT tblAssetManagement.[Installed PC Name] FROM tblAssetManagement;"


Thanks in advance for the help.

 

[oharab]

It's a bit of a kludge, but you could create an empty record in the table tblAssetManagement.
Failing that you are looking at creating a custom formula to do it.
Have a look in the help for creating a custom function for combo box.
I'll have a look at it when I get to work & get beck to you.

Ben ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------