Search results

Yes, the datasource is a query and it will accept input. As I said before, I can bypass the main form and enter data. I have several other subforms all functioning correctly but this is the only subform within a subform so I think there must be some conflict between this and the main form but...

Hi, Hoping someone can help with what I need to do to allow the following to work: I have a main formlinked to a subform, within the subform, I have a second subform. I am able to edit and add data in the main form, and the first subform. I am not able to edit or enter data into the second...

Hi, Currently have a database set up as follows: MainForm containing: Subform1 Subform2 OLE object (Spreadsheet file) Subform 1 is linked to MainForm via the field Year Subform2 is linked to Subform1 via a field in MainForm which shows the current record in Subform1 There is also an...

Sorry for the late response, got back to looking at this yesterday and managed to do it as you described. Thanks for all the help!!

Thanks for the responses. I'm not knowledgeable enough on this to write my own code to do this. I will try to give a bit more information. The main form is more or less a list of years from a table of years the field [Year] is linked to subform1 which is a list of species seen in that year...

Hi, New to the site and hoping someone can help me with the following: I have created a form which contains 2 subforms. The 1st subform is linked to the main form and displays data in continuous form view. The second subform is unlinked. It shares several fields with the 1st subform but...