Search results

I'm trying to update a subform using record source. As you can see when I state: Forms![main]![sub].Form.RecordSource = "Select * from [query]" this only results in my subform having one record whereas the actual query has 507 records. Please could you tell me how to assign the data in the...

I recently had to upgrade to ms 2007 and one of by sub forms no longer refreshes. The database needs to stay in ms 2000 format. When I press a button from the main form a script is run generating a query. I am trying to apply this query to a subform and have tried various permutations and...