Recent content by mikej

Very confused now.... I created a new database and main form, then copied just the troublesome parts to the new database. The search worked fine which seems to indicate the code is okay. The part of the system that has been causing problems consists of two subforms. A module, triggered by...

Generally no records sometimes one record, never the same as the underlying query. Tried copying the code to a new database with the same forms recreated and it works. Very confusing!

Both Link Master Fields and the Link Child Fields properties are blank, As I say if I open the sub form separately or look at its underlying query I can see the data displaying correctly.

There is nothing in the filter. If I open the subform as a separate form I can see all the data, but when the subform is in the main form I can only see the form's header and footer.

Thanks for the suggestion. It does not make any difference sadly.

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...