How can I return the name of the field that I had the focus on

[wassimdaccache]

Hello guys,

I am trying to search in a form name "employee_list" every unique field.

The idea is to return the name of the field that had the focus

I am trying to write this

 Dim y As Variant
 y = Application.Screen.PreviousControl.focused
x = InputBox("Please Enter Your Critiria", "Filter Product List")
DoCmd.OpenForm "employee_list", , , "[y] LIKE '" & [x] & "*'"
 

I am getting in a error with.

 y = Application.Screen.PreviousControl.focused

Please advise me

Thank you in advance


WASSIM S DACCACHE

[missinglinq]

Should be

y = Application.Screen.PreviousControl.Name

The fact that the f in focused wasn't capitalized when you moved off the line tells you that focused isn't a valid property.

Linq ;0)>

[wassimdaccache]

Should be

y = Application.Screen.PreviousControl.Name

The fact that the f in focused wasn't capitalized when you moved off the line tells you that focused isn't a valid property.

Linq ;0)>

Appreciate you feedback.

Could you please help me by getting the data of the previous field focused.
I mean the content (data)

by the way why on my access vb page when I write previouscontrol and then DOT a combo will automatically expand and it is not containing the "name" property.
Thank you in advance


Best Regards;

WASSIM S DACCACHE

[missinglinq]

Content = Application.Screen.PreviousControl.Value

and actually, the .Value is not neccessary, as Value is the Default Property of textboxes, comboboxes, etc. so

Content = Application.Screen.PreviousControl

will work just as well!

Linq ;0)>

[wassimdaccache]

Content = Application.Screen.PreviousControl.Value

and actually, the .Value is not neccessary, as Value is the Default Property of textboxes, comboboxes, etc. so

Content = Application.Screen.PreviousControl

will work just as well!

Linq ;0)>

It works I appreciate you quick reply :)


THANK YOU VERY MUCH


TAKE CARE

[missinglinq]

Glad we could help!

Linq ;0)>