Hi Folks
It's been a while since I've been on here (and since I've done access work).
I have a new database and on the main form i have a combobox that searches company names and then displays the relevant record. This works fine (although I would like to hone the recordset so that the form only displays the three records associated with that company rather than just going to the first record relating to the company - currently working on that but any suggestions/ pointers welcome ).
I created another combobox search to search on project name. Again this works fine BUT not every record has a project name. As a result the combobox list has a lot of blanks in it......how do I get it so that the combobox does not display null values?
thanks in advance
It's been a while since I've been on here (and since I've done access work).
I have a new database and on the main form i have a combobox that searches company names and then displays the relevant record. This works fine (although I would like to hone the recordset so that the form only displays the three records associated with that company rather than just going to the first record relating to the company - currently working on that but any suggestions/ pointers welcome ).
I created another combobox search to search on project name. Again this works fine BUT not every record has a project name. As a result the combobox list has a lot of blanks in it......how do I get it so that the combobox does not display null values?
thanks in advance