Drew Wutka
DWUTKA at marlow.com
Thu Apr 3 16:57:38 CST 2003
So let me get this straight. You need to display a form, that has 'two' fields at top, one is the name of the field that had an error, and the second is the value of the field. Right? (Do you need to display the rest of the data too?) Drew -----Original Message----- From: Gowey Mike W [mailto:Mike.W.Gowey at doc.state.or.us] Sent: Thursday, April 03, 2003 10: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