No records showing in Form

[BAzZ]

I have just created a form based on a query of a number of tables, when I enter data into the form, the data goes to the tables, but when I close the form and re-open it, the records I have entered aren't displayed. I opened up the query and it didn't show any results, but again like the form I can enter records into it but when I close the query and open it still not showing any records.

Any help would be appreciated

 

[bradcccs]

Bazz,

It sounds to me that you are writing to only one side of the inner join in your query.

ie: You have an innerjoin between two tables (Only include rows were the joined fields from both tables are equal)
Your query is writing to one half of the joined relationship (one of the tables only). Thus when you re-run the query, these fields are not equal, and do not appear.

Sorry if that sounds confusing. Even I struggle to understand myself sometimes

Cheers

Brad.

 

[BAzZ]

Thanks again for you help,

I have been just looking at that, a fellow colleague has just pointed out the same mistake. I'm working on creating the query again.

Thanks