MastercafeCTV
mastercafe at ctv.es
Sat Apr 2 16:30:50 CST 2005
Thats exact... This is that i was looking for. We wanted refresh a subform while you are typing on the main form field. Put this on KEYPRESS event Campo is a Combo with all names of fields and its description. The answer is very good and fine. Dim TMPBuscar as string TMPBuscar = Me.buscar.Text Me.fl_ClientesSubform.Form.RecordSource = "Select * from [BASE CLIENTES] where [" & campo.Column(1) & "] like '" & TMPBuscar & "'" Me.fl_ClientesSubform.Requery Thanks -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of dmcafee at pacbell.net Sent: viernes, 01 de abril de 2005 20:40 To: Access Developers discussion and problem solving Subject: RE: [AccessD] Taking the value .Text -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MastercafeCTV Sent: Friday, April 01, 2005 9:51 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Taking the value We are trying to take the value from a field in a form during the writting from the user. If we take me.StrField we obtain the last value until go to the next field. It's possible take the value? Thanks Juan =========================================== MASTERCAFE S.L. NIF - B 82.617.614 Juan Menéndez Crespo Plaza Puerta de Europa 2, 1-D (33011 Oviedo) www.mastercafe.com info at mastercafe.com =========================================== El contenido del presente correo es privado. Todos los archivos adjuntos han sido revisados y escaneados con McAfee VirusScan 8. Solo serán válidos aquellos archivos que estén identificados en el cuerpo del correo y que se describa su composición y contenido del mismo. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com