I ahve a from with several child tables. One of those needs to have a new record added from the parebt form. What I would like to do is allow that to happen fron an existing combobox. The box has:

Rowsourcetype = fields
rowsource = child.text,child_key
colums = 2
bound colum = 2
col widht = 50,0

In the Lostfocus event, I would like to (p-code follows)
if colum2 isnull
insert into child (text) values (colum1)
this.value = child.child_key
this.requery
endif
this.refresh

But I am darned if I can find a way in provided samples to check a single coloum.