Form data not in Report

[aronw]

I have a problem. I hope this is the right forum to mention it in. It appears to be a problem with my form writting data to 2 of the three tables I have. This problems only occurs with the new records that create through my forms.

What happens is that although the forms seem to retaining the data entered, when I go to generate a report the data is not all there. Only data that is stored in one of the tables shows up. Any ideas?

TIA

Aron

 

[skwilliams]

You say your form is storing data in three different tables.

Are these tables all related through a primary and foreign keys?

Is the form's control source one table with the other two tables being controlled by subforms within it?

This might help narrow the possible problem.

Steve

 

[aronw]

The answer to you questions is yes, the Pk & Fk are the same ID (autonumber) fields, which due to the fact I have no unique data are in each table.

Both the forms record sources are a query (the same one). All my forms are form in their own right, connected together via command buttons. Thanks for the response, it is proving to be a difficult little glitch to remedy. Still any help would be great,

Aron

 

[saintsman]

I would examine the query that your report is based on. If the information is being saved on your form then it is in a table somewhere. Therefore you can get it out.

You are either looking at the wrong table or the query has restricted the data you want to see. Run the query and see if the data you require is there. If not then amend it.