Search results

Thank you Paul. It's exactly what I needed

Oh wow... I just realised now how vague my question was. You're reply was absolutely perfect for my original question pbaldy, however, what I really want to know is: I need to test both controls, if they are empty throw a message, if only one is empty run the query with the where clause for...

Hi pbaldy, Thank you for your quick response. Will you be able to explain what you mean? Here is my current code if that will help: Dim rsPG As DAO.Recordset Dim vRow As Long, vCol As Long If Not IsNull(Me.itemNumTxt) Then 'Fetch data from query and copy into...

Hi, First off, I am extremely new to Access programming and I apologise if I sound stupid. I have a form with a combobox, textbox, a button and a listbox. Currently the button checks if the textbox is empty and if it is, it runs a SQL query to select data using the combobox value in the...