Read value from Combo Box

[ksbigfoot]

I am stumped trying to get this to work.
I am inserting a new record into a subform, but before the record gets inserted, I want to check to see if the record already exists but isn't being displayed (because of a display flag set to false). If the record has a display flag = false, I want to cancel the insert, set the flag to true and refresh the datasheet.
My problem is that when I pick a value from the combo box and the Form_BeforeInsert event gets called, I am trying to read the value from the combo box, but I can't seem to find the correct code to read the combo box. I am not even sure if BeforeInsert is the right event.
I thought I was able to use the Me.cboPipeID to retrieve the value.
Can someone point me in the right direction?
Thanks

 

[ksbigfoot]

I didn't understand how the Before_Insert event worked. The Before_Insert event gets executed as soon as a key is pressed, that is why I couldn't read the combo box. I moved my code to the Before_Update event and it is working.
Thanks