Help with checkbox

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

Guest

I have a main form & a subform. My subform pulls one piece of info from my
main form. I have a checkbox on my subform that I would like to enter two
pieces of data into a 3rd table if possible, when the box is checked. Can
someone please help me!

Main - ID
Sub - I enter name, ID pulls and populate's table on its own.
I need a checkbox next to name that, when checked, will populate table
[Review] with both name and ID. Can this be done and how?
 
In the "on exit" event for the check box test for true(-1) to open a
form for the third table. the form for the third table could have
Default values for the ID# etc set to the main form or you could use
SetValue function thru a macro. or
Me![thirdformfield.Value=Me![firstform]field value. etc etc

HTH
Tony
 
Back
Top