Combobox Works for me but Client hates it... dlookup won't sort so I'm screwed

[franknyt]

I have form with a datasheet embeded.


Have a combobox that autopopulates text field. Yay!

BUT :(

Client does not like nor want a combobox, prefers free text typing (combobox while typing trys to auto-fill, causing frustration and mistakes).


Dlookup won't work because the autopopluted field needs to be sortable. dlookup fields won't allow you to sort.


e.g. Type "N1" on textField and updates other field to "25," and that field ("25") column is sortable: A-Z or Z-A.

Thank you!

[pbaldy]

You can place a value in the second textbox in the after update event of the first:

Me.SecondTextbox = DLookup(...)

[franknyt]

You can place a value in the second textbox in the after update event of the first:

Me.SecondTextbox = DLookup(...)

OH! I'll try that, thanks!!!

[pbaldy]

No problem, post back if you get stuck. Welcome to the site by the way!

[franknyt]

Hey pbaldy,

I couldn't get it to work. I believe I got the syntax right but I don't think I placed it in the right place and triggered right.

I'm placing it on V12 Validates text field onChange


Me.V12_Ranking = DLookup("Ranking", "Validation_Codes", "validation_code=" & [V12 Validates])


The two fields in datasheet are:
"V12 Validates," text field where the code is entered.
The second field is what needs to update, "V12_Ranking." This field needs to be sortable in datasheet view.

The table "Ranking" is being looked up in is:
"Validation_Codes"

Field Names In Validates_Codes table:
validation_code
Ranking

Thanks, and sorry for the rainbow.

-Frank

[pbaldy]

Try the after update event; the change event requires you to use the .Text property, but also fires on every keystroke which typically isn't desired. Also if the code is text it requires delimiters:

http://theaccessweb.com/general/gen0018.htm

[franknyt]

Try the after update event; the change event requires you to use the .Text property, but also fires on every keystroke which typically isn't desired. Also if the code is text it requires delimiters:

http://theaccessweb.com/general/gen0018.htm

At first I was "OH!," then I was like "wtf," but then I was like "HOLY SHIT, IT WORKED!"

THANK YOU SO MUCH! You really helped. I truly appreciate it, pbaldy.

-Frank

[pbaldy]

Lol! Happy to help!