[AccessD] Cheecking field exists

I use something like:

	'(air code)
	On error resume next 
	td=currentdb.tabledefs("sometable")
	strFld=td.fields("somefield")
	if err.number=0 then 	'field exists
         somecode
	   else			'field does not exist
		someothercode
	   end if
	on error goto Proc_Err	'reset error handler

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Thursday, May 18, 2006 11:13 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Cheecking field exists


Is there an easy way to check if a field exists in a particular table vai
vba?
 
Maritn
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477