By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,589 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,589 IT Pros & Developers. It's quick & easy.

Problem with Form which contains two Subforms

P: 13
Good morning,

I have the following structure:
Form Frm_Production_Main which has two Subforms
SbFrm_Production_Sub_MLCD and
SbFrm_Production_Sub_TB.
These forms are linked to tables:
Tbl_Production_Main
Tbl_Production_Sub_MLCD
Tbl_Production_Sub_TB

The Record Source for the Form is the following:
Expand|Select|Wrap|Line Numbers
  1. SELECT Tbl_Production_Main.*
  2.      , Tbl_Production_Sub_TB.BC_ID
  3.      , Tbl_Production_Sub_TB.Traceable_Batch
  4. FROM   Tbl_Production_Main
  5.        INNER JOIN
  6.        Tbl_Production_Sub_TB
  7.   ON   Tbl_Production_Main.Batch_Card_ID=Tbl_Production_Sub_TB.BC_ID;
I notice that Tbl_Production_Sub_MLCD is not mentioned?!

I built the form structure from a copy of previous structure that did not have subforms.

My problem is that new records that I add currently are added to the tables, but cannot be displayed in the form after entry? I know I must have done something wrong but I am not sure what.

Any advice would be much appreciated, thank you.

Anton
1 Week Ago #1
Share this Question
Share on Google+
1 Reply


P: 13
It's ok, I've worked it out, there were entries missing in the sub table!
1 Week Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.