Goto first record where certain field is NULL 1

[micang]

Access 2003

Hi All,

I have subform(datasheet view) that after an update event from a combobox on a main form, the recordsource gets set and displays the records required. What I would like to do after this,is go to the first record in a specified field, that is NULL.(I don't mean filtering it, but that record must be the selected record).

I am not sure what I can use to achieve this, maybe the gotorecord command, but I can't seem to figure out if you can put a "find" criteria on gotorecord?

Any info getting me started on the right direction will be appreciated.

Thanks
Michael

 

[MajP]

Dim rs As DAO.Recordset
Set rs = Me.yoursubformcontrolName.form.Recordset
rs.FindFirst "yourfieldname is null

 

[micang]

Thanks MajP, you have helped out once again.

Appreciate it.

Michael