[AccessD] Retrieving a Record Field

You can reference the particular control that contains the error
something like this:

Me("txt" & Me.txtErrorField).SetFocus

I'm assuming that txtErrorField is the name of the control that holds
the field name where the error occurred and that your control name has a
txt prefix before the name of the bound field.  If not, you would need
to tweak this line appropriately.  The idea is to use the name of the
field in txtErrorField to index the form's controls collection.

Charlotte Foust

  
-----Original Message-----
From: Gowey Mike W [mailto:Mike.W.Gowey at doc.state.or.us] 
Sent: Thursday, April 03, 2003 8:53 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Retrieving a Record Field



Hi Everyone,

I have a a need to pull a field from a record in a database when the
field name is listed in another Field.

What I am doing is I have a flat file that is imported into an Oracle
database and it is run through a filter that checks the validity of
certain fields in each record.  If the record does not pass the filter
the record is put into a temp table and the field name that has the
error in it is put in a new field.  I need to be able to display the
field with the error on a form when the record is brought up.  This will
allow the end user to fix the record.

Is this possible???

Thanks,
  
Mike Gowey, MCP
Technical Support Analyst
SRCI ISSD Team Leader



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com