Why does this table popup?

[twillingham]

I am working in a database used to register students for Cooperative Education at a University. When we register students, we have a form with their information, that contains a subform that contains the actual interview times registration for each student. In the original database (before my time), when you click in the subform to choose a time for a student to interview with a particular company, a table (query?) pops up showing the current times that are already registered for that company to help prevent double booking. I am trying to implement this in our current access database, but I cannot figure out what is making this popup in the original. There is no macro or vba code associated with this as far as I can tell.

Thanks in advance for your help!

[ranman256]

It could be the relationship. If 2 tables have it, Access will show a parent-child table.

[John_G]

Hi -

If the table/query pops up in response to a click, there has to be code or a macro do do it. Most likely this is in the code for the sub-form. Open the sub-form in design view, click the "Design" tab on the ribbon, the click "View Code" to open the code module, and look for a _Click event.

Are there any macros in the database that look as if they might open something?

HTH

john

[twillingham]

Thanks for the replies. I have read the documentation on parent-child and see no reason for anything to popup.

As far as macros, there are none relating to this function that I can find. As far as code, there is none in this database.

Any other suggestions? Thanks!