How do I populate my main table from a subform in access 2003

[dausa]

Hello,


I am an intermediate user of access 2003 and new to AccessForums.net.

I need to know how to make a subform populate my main table.

What I have
I have a main form that has a couple of subforms on it.

• The subform has three fields, one being a combo box that populates the other two fields.
  
  • OLD CAGE CODE (Combo box)
    
  • OLD STATUS
    
  • OLD COMPANY NAME

What I need
After I fill in the combo box and the two other fields update on the form, I need that information to be populated on my main table.


Thank you in advance for any help.
Clay

[RuralGuy]

Normally a Form/SubForm arrangement is used to deal with a 1:m relationship. It sounds to me like whatever you have in the SubForm should be on the MainForm instead.

[dausa]

Thanks for the reply.
The sub form is located on the main form. The only way that I knew how to add the combo box look up was to do it on a subform then add it to my main form.

I am including a snap shot of my form in design view. Not sure that this will help but here it is.

[RuralGuy]

Forms are simply windows into the RecordSources of tables and queries. What is the RecordSource of your SubForm and where on the MainForm were you planning to include the additional data?

[dausa]

My recordsource for the subform is Cage_Code_tbl. I am attaching different screen shot of the form in form view.


Here is a screen shot of the main table PBOM_TABLE.


The information that I want does populate on the form. In other words, the combo box does work correctly but once the data populates on the main form, I can not figure out how to get it to the PBOM_TABLE.

The PBOM_TABLE is where I have all my data (that's working correctly) go to so that I can build reports against the data. The form itself I use to manage the PBOM process.

The may be to much info or the wrong information. Sorry if it is not, but I really do appreciate the the help. GREATLY.

Clay

[orange]

In "business terms" what is the relationship of the data on the Main form and that on the subform? Forget the combobox for the moment.

As RG said you normally have a 1:M set up.
for example, a Person(1 side) has many(M) Hobbies where Person is on MainForm and a list of his/her Hobbies is on the subform.

[dausa]

Hi Orange,
As you can tell you are basically helping "Larry the Cable Guy" over here. I only have what I have taught myself and no formal training. I really appreciate everyone being patient and trying to help me.

The main form is 1:M
The subform is 1:2

• Objects that the subform depends on: Cage_Code_tbl
• Objects that depend on the subform: Main form

So, to explain it in my terms..... The subform is only used from / on the main form and draws its data from the Cage_Code_tbl.


I need to make a correction to my original statement

What I have
I have a main form that has a couple of subforms on it.

• The subform has two fields not three. The combo box is not actually in the subform.
  
  • OLD CAGE CODE (Combo box) Not apart of the subform.
    
  • OLD STATUS (text box)
    
  • OLD COMPANY NAME (text box)

The information that I put in the combo box does populate the PBOM_TABLE the way that I want it to. However, the two text box fields populate and stay on the form correctly but do not populate / move to the PBOM_TABLE correctly.

Thanks again.

[orange]

I need to make a correction to my original statement

What I have
I have a main form that has a couple of subforms on it.

• The subform has two fields not three. The combo box is not actually in the subform.
  
  • OLD CAGE CODE (Combo box) Not apart of the subform.
    
  • OLD STATUS (text box)
    
  • OLD COMPANY NAME (text box)
  
  

The information that I put in the combo box does populate the PBOM_TABLE the way that I want it to. However, the two text box fields populate and stay on the form correctly but do not populate / move to the PBOM_TABLE correctly.



I'm confused. You are correcting your earlier post
You have 2 subforms, then you say the subform.....

Please describe exactly what you have?

[dausa]

Sorry about the confusion. So when I said; "I have a main form that has a couple of subforms on it", that was accurate. However, the other details are regarding only one of the subforms. One subform is difficult enough for me to describe so I figure if some one can show me how to do one, then I can apply the same logic to the other which is an exact duplicate of the first. So let me correct the statement.


What I have
I have a main form that has a subform on it.

• The subform has two fields not three. The combo box is not actually in the subform.
  
  • OLD CAGE CODE (Combo box) Not apart of the subform.
    
  • OLD STATUS (text box)
    
  • OLD COMPANY NAME (text box)

The information that I put in the combo box does populate the PBOM_TABLE the way that I want it to. However, the two text box fields populate and stay on the form correctly but do not populate / move to the PBOM_TABLE correctly.

Hopefully that makes more sense. lol

[RuralGuy]

I guess I would have to ask why you have a SubForm here?

[dausa]

It is the only way that I know how to have data auto populate on the form.

• The long term goal is to have the form auto populate as much data as possible so that I do not have to do it all manually.

This is the first access data base that I have built and I have no formal training except for a couple of three day classes. I'm sure you have already guessed that. lol

[RuralGuy]

What are the ControlSources of the three controls in question?

[dausa]

Here are the control sources from the main form view.

[RuralGuy]

Okay, now what do you have in the AfterUpdate Event of the ComboBox?

[dausa]

Nothing at all.