form/subform reference problem

[dbertanjoli]

I would greatly appreciate if someone can take a look at my attached access database (2003 version).

My main form has a list box with names. By selecting the name I then click on the resecarchcategories subform to enter data for that person. After entering a first record and want to add another one by using 'add another' this button breaks into debugging mode. There is something wrong either with my 'add another' button or my 'next' button functionality.

I would greatly appreciate your reply.
Debbie

[ConneXionLost]

Hi,

A typical arrangement for a subform is to be embedded into a form using the "Subform/Subreport" control. You don't appear to be doing this. Instead, you have a textbox you're trying to coerce into acting as a subform with VBA. Additionally, your Record Source for frmResearchCategory is a query with two tables.

If you were to return to the "typical" approach, you might be able to take advantage of the Master/Child relationship inherent in a form/subform, instead of trying to recreate it with VBA.

Cheers,