Sorry, i think i left out an End IF at the end of my eg.

Ok, how about opening the table and check that the ID exists using ADO. e.g.

DIm rst as ADODB.recordset

dim varVal as variant

Dim strmsg as string

dim strSQL as string

varVal = me.txtMyID

If isnull(me.txtMyID)...

It looks like you should try using a combobox that displays a list of acceptable "ClinicianID" values, and set the combo "LimitToList" property to true, so no other data can...

Hi,

This may be the problem,

Whenever i get that error message when trying to create an mde/ade file, the problem has always been caused by a compile error in the vba...