Auto Populating a form field after entering a number into a different field.

[JayV]

I've created a data entry form. I have multiple fields but the fields "Road Log #" and "Road Name" I want to be bound to each other. I also have a table that lists out 1200 road log numbers and their corresponding road log names. I want the number that is entered into "Road Log #" to auto populate the "Road Name" with the correct name from the table. Help? I don't know much about the expression builders. But I tried messing around with things all morning and I didn't really get anywhere so I figured I'd try here.

[PEB]

Hi,

One of those fields is it a combo box with the list of choices or the user is prompted to select directly without list?

Best regards

[JayV]

I can set it up either way. Right now they're entering the road log number manually and then selecting the road name from a list. The easiest way would be to select the road name from a list and have the number autofill.

[PEB]

So, you create this combobox

In he after update event you choose after update event procedure

And in the white window in VB you type:

Me![Road#]=me![RoadName].column(1)

So about the combobox..

When you chose the control source press on the ... bouton to create your own query. Choose the roadname column and raod# column as second column. Close the query builder

Then update column count property of your combobox = 2

Bound column=1

It should work!

Best regards

I can set it up either way. Right now they're entering the road log number manually and then selecting the road name from a list. The easiest way would be to select the road name from a list and have the number autofill.

[lefr]

Does anyone know of a Tutorial that covers what PEB posted? I'm a noob, and don't want to waste anyone's time with rudimentery questions that have already been discussed, but the whole "white window in VBA is throwing me"

Thanks