filter form using the previous focus

[wassimdaccache]

Hello sirs;


I do have a continuous form on MS access 2003 I would like to filter this form using the content of the field. I am using this code.

Dim y, x As String
y = Application.Screen.PreviousControl.Name
 
    x = Application.Screen.PreviousControl.Value
 
Me.Filter = "[y]= " & [x] & " "
Me.FilterOn = True

I think access is not understanding the Y.

Any suggestion or help.

Best regards;


WASSIM S DACCACHE

[nico5038]

When your control holds the name of a valid field, use:
Me.Filter = y & "=" & x
when it's a numeric value, or for text:
Me.Filter = y & "='" & x & "'"

Getting the idea ?

Nic;o)

[wassimdaccache]

Yeah it works thank you .


How can I know the field type if string ,number or boolean


Any suggestions would be helpful.



THANK YOU


wassim s daccache

[nico5038]

You'll have to look that up in the table definition. Just open the table the field is located in design mode.

Nic;o)

[wassimdaccache]

Yes I know this method but actually what i am looking for is to have a code that reply for me the field type in my form so it will be easy to implement my code by just assigning 1 button to all fields used in my form.(my table contains 55 fields)

Best regards;


WASSIM S DACCACHE

[nico5038]

You'll need the Field property Type to determine this. From the helpfile:

For a Field object, the possible settings and return values are described in the following table.
Constant Description
dbBigInt Big Integer
dbBinary Binary
dbBoolean Boolean
dbByte Byte
dbChar Char
dbCurrency Currency
dbDate Date/Time
dbDecimal Decimal
dbDouble Double
dbFloat Float
dbGUID GUID
dbInteger Integer
dbLong Long
dbLongBinary Long Binary (OLE Object)
dbMemo Memo
dbNumeric Numeric
dbSingle Single
dbText Text
dbTime Time
dbTimeStamp Time Stamp
dbVarBinary VarBinary

Nic;o)