Searching error 2455

[D.Mair]

I think this is caused by the

on current code looking for info from a sub form

the subform looks at the current form for job number to calculate year

the year is then used to create the file path.

I think it is finding the year to late.

this could i suppose be solved by storing the year but i thought you lot would have some pther way round the problem.

Thanks, once again for any help.

David

 

[The_Doc_Man]

Both your parent form and your child form have their own class modules. Data on any form is "local" only to the individual class module for that form. However, as far as I understand it, the "On Current" event for the sub-form SHOULD occur only after the parent form is fully open and available. Which means its data should also be available through appropriate syntax.

The Access Help files should provide adequate examples for how to reach back from a child to a parent to get data from the parent. The trick is to do it from the right class module.