Updateuing a form from a table - PLEASE HELP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey guys,

I have a main table that has PO information on it.. And several forms per
department that fill out other information regarding a certain PO that table..

The first form has the main Purchase Order data for the table..

Then the next 6 forms I have data relevant to a PO.. I have drop down boxes
for them to pick a po that is already on the table but I can't figure out how
to make it automatically update the form as soon as they fill in that drop
box, pull the first main forms data (first few columns fromt he main table)
onto the form so they can see info about the PO as they add their relevant
department info for that specific PO..

I hope this makes sense.. please help..
Thank you.
 
Amy said:
Hey guys,

I have a main table that has PO information on it.. And several forms per
department that fill out other information regarding a certain PO that table..

The first form has the main Purchase Order data for the table..

Then the next 6 forms I have data relevant to a PO.. I have drop down boxes
for them to pick a po that is already on the table but I can't figure out how
to make it automatically update the form as soon as they fill in that drop
box, pull the first main forms data (first few columns fromt he main table)
onto the form so they can see info about the PO as they add their relevant
department info for that specific PO..

I hope this makes sense.. please help..
Thank you.

If I understand you correctly, you need to code the combo boxes' After
Update events with something along these lines. Obviously you will need to
modify the code slightly to match your own field/control names:

Private Sub MyCombo_AfterUpdate()

With Me.RecordsetClone
.FindFirst "PO_id = " & MyCombo
If Not .NoMatch Then _
Me.Bookmark = .Bookmark
End With

End Sub
 
Back
Top