Autofill textboxes based on combobox value (1 Viewer)

Simona14 · Apr 28, 2018

Hi! I'm trying to populate text boxes based on a text in a combobox. I've tried using a dlookup in the textbox's control source but i can not figure out what i'm doing wrong. The values in the combobox are populated with the table "Persons" Region value.
=DLookUp(“[Name]”,”Persons”,”[Persons].[Region] = “”” & [Combo17].[Text] & “”””)

moke123 · Apr 28, 2018

First thing you should do is change the name of the "Name" field as that is a reserved word.

there are several ways to achieve what you want and a little difficult to understand with so little info.

Does your Dlookup return what you want?
if so you can use it in the after update event of the combo with something like
Me.YourTextBoxName = DLookUp("YourField","YourTable","YourCriteria")

arnelgp · Apr 28, 2018

Is your form bound?
What is the rowsource if combobox?
What is the recordsource of your form?

pbaldy · Apr 28, 2018

If the values can be included in the combo row source:

http://www.baldyweb.com/Autofill.htm

Pat Hartman · Apr 29, 2018

Here's an example that shows how to do this. Look at example 4.

Autofill textboxes based on combobox value (1 Viewer)

Simona14

New member

moke123

AWF VIP

arnelgp

..forever waiting... waiting for jellybean!

pbaldy

Wino Moderator

Pat Hartman

Super Moderator

Attachments

Similar threads

Users who are viewing this thread