Solved Show the value without opening the DropDown List (1 Viewer)

[Sarah.M]

Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity).
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
I want to Show the value without opening the DropDown List, I put the syntax on Default Value but still not working I got error #Type! as shown in the picture
if you have better way I appreciated
plz help me

Sample DB Attached

 

[mike60smart]

Hi Sarah

Why complicate things.

The Form should be bound to EmployeeT

Then just use a Combobox in the Header of the Form.

Very easy to create and easy for the user.

But try this version attached.

 

[Sarah.M]

Hi Sarah

Why complicate things.

The Form should be bound to EmployeeT

Then just use a Combobox in the Header of the Form.

Very easy to create and easy for the user.

But try this version attached.

Thank you for your reply
No, I want when I type something or when I paste text on txtSearch, I want it to appear directly in the list without opening it
so I use DLookup in Default Value
Try to help me to make it happened

 

[mike60smart]

Thank you for your reply
No, I want when I type something or when I paste text on txtSearch, I want it to appear directly in the list without opening it
so I use DLookup in Default Value
Try to help me to make it happened

Have you tried typing something into the No 2 Textbox?

 

[Sarah.M]

Have you tried typing something into the No 2 Textbox?

Yes I did it works if I open the fullname list,
But wht I need, is the result appears aumaticly in the list without opening fullname list
I want to let Ms Access, when I type something and it matches, any thing in the list pick it and show it by your self
I apologize, I try to explain as best I can

 

[mike60smart]

Yes I did it works if I open the fullname list,
But wht I need, is the result appears aumaticly in the list without opening fullname list
I want to let Ms Access, when I type something and it matches, any thing in the list pick it and show it by your self
I apologize, I try to explain as best I can

Sorry I can only get this to work by using VB

Can't get a Macro to do it

 

[gemma-the-husky]

I don't know how expert Mike is in macros, but I imagine many of us are just used to using code and might not understand macros well enough to achieve the same result with a macro, even if it is possible. I'm sure we've had discussions about ridiculous IT practices like this. Maybe with yourself. It's just crazy.

 

[isladogs]

Whether or not you have to use macros, this is the opposite of the normal approach
Normally you select an item from the combo box and the selected item can then be displayed in a textbox
Trying to do the opposite makes no sense

 

[GPGeorge]

I have used a similar technique to filter items for a list box, but not to try to select one item in a list in a combo box. As Colin said, that's just the opposite of this projected approach.

Implementing it with a macro certainly seems like a stretch, too.

All of that said, it might be an interesting challenge.

 

[GPGeorge]

If I understand your requirement correctly, this is an example of one way to filter a combo box list using a contains search in a text box with a macro.

 

[mike60smart]

If I understand your requirement correctly, this is an example of one way to filter a combo box list using a contains search in a text box with a macro.

Hi George

You did exactly the same as me.
However the Op wants the value to be displayed automatically in the Combobox

 

[GPGeorge]

Hi George

You did exactly the same as me.
However the Op wants the value to be displayed automatically in the Combobox

With macros that is hard to do.

 

[bastanu]

Maybe something like this?

 

[mike60smart]

Maybe something like this?

Very neat

 

[Sarah.M]

Maybe something like this?

Very beautiful and very cool
but can we keep FullName Bound and use DefaultValue instead of RecordSource? to keep it bound and to keep the dropdownlist works as second option, just in case if dlookup did not find the name in txtSearch

 

[bastanu]

Sarah, you going to have to explain a bit more about the intended usage of this form; the default value of a control will only apply to new records, yet you seem to want to build some sort of search utility which implies loading existing records.
Cheers,

 

[Sarah.M]

Sarah, you going to have to explain a bit more about the intended usage of this form; the default value of a control will only apply to new records, yet you seem to want to build some sort of search utility which implies loading existing records.
Cheers,

It works Thanks!

 

[bastanu]

Glad to hear! Good luck with your project!

Cheers,