Form after close and reopening not picking up fields

[colenzo]

Hi All,

I had an issue the other day that had a simple fix, since then I have cleared the data out of the database and started testing it to check its usability.

I entered in a full record, and flicked back and forth between the records, and everything was looking good.

Then I closed the form, and re-opened it and my record was no longer populating the form fields.

I've literally changed nothing bar one field that was changed from number to text, I refreshed this field in the form, but now I can't figure out what's gone wrong.

:banghead:

 

[pr2-eugin]

Because there is no data in the table? I entered some information and it happens to save.

 

[colenzo]

I had full records entered, and saved, and then re-opened the form and it was not showing any records....

 

[pr2-eugin]

I am confused, It does for me..

EDIT: Okay I now see your point, it is because, you have INNER JOINS, this setup is not efficient.. As the Set up you should be having is Main Form/Sub Form, not everything in one big Form. If you would like everything in one whole Form, then you need to make sure all table's information are entered.

As JOIN would work only if all fields are matched up. In simple words, if the other table that you are joining does not have the Corresponding FK then the Data will not be pulled across.

 

[colenzo]

ah, ok I think I understand what you're saying, not sure how to fix it but i'll have a play and try and figure it out!

I'll have to go down the subform route as it needs to be one 'form' as such as it will be used for quick access information, updating and entry. I can think of a quick fix but its not feasible in the long run, and that would just be a simple tick box that all tables would record on entry, but I know that would be bad in the long run!

 

[pr2-eugin]

Creating SubForm for MainForm is not hard at all.. Its very simple, efficient and also easier layout.