By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,093 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

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

P: 2
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.
Oct 9 '06 #1
Share this Question
Share on Google+
4 Replies


PEB
Expert 100+
P: 1,418
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
Oct 14 '06 #2

P: 2
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.
Oct 18 '06 #3

PEB
Expert 100+
P: 1,418
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.
Oct 21 '06 #4

P: 3
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
Nov 29 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.