Passing data from sub form to main form

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

Guest

I i got a dilema i am working on, i have main form and some look-up forms, i
want to be able to open look-up form from main form using button, make some
selections and store them to variable than get data back to main form and
write it to db. Any idea on where to start ?
 
Hi
I assume the look-up relates to data on the main form. When you make a
selection on the lookup, use the close event to move the information back to
the main form. Do a requery of the main form and you should be fine.
Something like

Forms!frmMain.result = Forms!frmLookup.field1
Forms!frmMain.Requery
 
Back
Top