Search results

Hello again. Thank you to everyone who became involved in this. I now have a solution. Many thanks

This is the first time i have posted on a forum and probably have not been as clear as to what I'm doing as I need to be. I have an access based database that records various connections. Most fields in the database are stored as they are required on the screen but two fields, each of which is...

Thank you for your reply doco, I hadn't heard of the nz() function before. I don't understand about the Rowsource property. The query is an SQL query in a function in a class module which returns an ADODB rcordset into the rsPopLst recordset in the form module. If I replace the line 'set...

I have the code below to query an SQL Server Backend database The first part uses a public function (populatelst) in a class module (clsCables) to query the database and return an ADODB Recordset to the rsPopLst Recordset in this module. If I assign the rsPopLst recordset to the RecordSource...