Subform not quite working

[JoeyB_99]

I'm using Access 2007, and developing a safety observation db application. There are 40 prescribed activties/safety practices to check for. This is a table with auto-number PK, description of activity, and active status. These activities are not static. More could be added, or existing ones could be made inactive.

The main table is the basic info - date and time of situation being observed, employee number of observer and description of work activity. This has a PK auto-number, as well as a foreign key to link up with the PK of the precribed activities table.

I made forms of both tables, and they work separately just fine. When I made the prescribed activities form a subform of the main form/table, and linked it up properly as PK to FK, no data appears in the subform when I go into View mode! Why is that? What am I doing wrong?

 

[vbaInet]

I have a form / subform / Query problem I need help with. I have a form with a subform and have used a query to generate a report from the information entered into the form. The query is related to the form by the following 2 where statements: [Forms]![frmPrescriptionsA]![fldRXID] and Forms]![frmPrescriptionsA]![frmDoses Subform].[Form]![fldDoseID].

The problem is that when I fill out a new record in my form and subform and then use the command buttons I have to either print or e mail the reprot that is based off the query the report is empty or unpopulated. If I go back one record then forward the the record I just entered the report now has the right information. I have tried a number of save commands to save the record first before trying to print or e mail and nothing has worked. Any ideas how to updat the form and query without closing the form or going to another record?

Winston please don't hijack someone else's thread. Create your own thread and post your question on there.

@JoeyB:

* Did you create the problem form using the Form Wizard?
* Do you actually have records in both tables that relate to each other?

 

[JoeyB_99]

Thank you vbaInet for responding.

The subform and main form were both created using the Form Wizard.

There are no fields that relate to both of the two tables, other than the PK (auto-number of the subform) and a foreign key in the main table that I made similar to the PK.

Is it possible for me to develop some query for the basis of the subform instead of the prescribed activities table?

 

[boblarson]

Winston please don't hijack someone else's thread. Create your own thread and post your question on there.

MODERATOR NOTE: I have moved Winston's post to its own thread.

 

[vbaInet]

If there's no common field between the record source of your subform and the record source of your parent form then they can't really be linked.

@boblarson: Thanks!