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

[RuralGuy]

I know the Cage_Code_tbl table contains the Status and Vendor fields. Do they also exist in the PBOM_TABLE table?

[dausa]

Yes sir they do.

[RuralGuy]

Could you post the SQL for the RecordSource of the MainForm please?

[orange]

Could you also post a jpg of your tables and relationships?

[dausa]

I work with SQL in SQL Developer and Crystal Reports but I do not know where to find the code for the whole form.

The only thing I could find is the code for after update. This is the main form in properties.

Private Sub Form_AfterUpdate()
Me.Refresh
End Sub 

[RuralGuy]

What is the RecordSource of the MainForm? Is it a table or Query? If Query the could you switch to SQL view and post that here?

[dausa]

Here are the screenshots of the tables and relationships.

[dausa]

The record source for the main form is the PBOM table.

[dausa]

Guys.. I will be off work until monday. I will answer any other questions when I come back.

Thank you both again for trying to help me where ever you can.
Clay

[dausa]

I am back at work if either of you are still wanting to help.
thanks
Clay

[orange]

Go to your main form in design view and look for any events.
Perhaps you could post what vba code you find.

[dausa]

In the After Update field the event procedure is

Private Sub Form_AfterUpdate()
Me.Refresh
End Sub

In the On Timer field the event procedure is

Private Sub Form_Timer()
Me.txtClock.Requery
End Sub

That is all the code that I have in the Event tab for the main form.

[orange]

How is the combo populated?
Did you build the database?
Can you create (from your database) a small database with the relevant tables and forms to show the issue?

[dausa]

I just got the problem solved by one of our computer guys that was passing through. Our MIS department does not support Microsoft Access at all so I knew I could not go to them for help. Fortunately, one of them was passing through my office so I took a chance and asked if he knew anything about Access. He likes Access so he helped me (even though he was directed not to help with Access).

Thank you all who tried to help. You guys are great!!!

God Bless
Clay

[RuralGuy]

Any chance you could post what he did?