Search results

I have a database where I am pulling my data in my subform from a tbl made by a make table query. However, Once a month the data will be updated and sorted by "Retrieve Date". I have made a function through a module that updates the queries with the latest retrieve date everytime new data is...

I agree a query would be easier, however, the users of the database want it to be in a VBA code format so the query does not have to run everytime but instead can be pulled from a table to save time. With that being said, is there a way to make this code work or is a query the only route to go?

I have made a form (frmLogin) that is used as my homepage and has command buttons that take the user to other forms. However, I am trying to make the txt box on the frmLogin be able to filter by a date found in a table (tblDefaults) when the form is opened. I am trying to pull the value from...