Auto fill-in text box on forms

[windwardmi]

I would like to reduce data entry.



I have related tables that I use to fill in a Project Form through combo boxes. i.e. Employee, Customers, Contacts, Vessels, Locations tables. I can edit all these tables from this form. After the form is completed a new project row is added to my Projects Table.

I want to reduce data entry for related combo boxes. for instance if I have a contact name manually filled in a combo box, I want his mobile phone to fill in the next combo box automatically.

How is this done and with what code if any.

Bear in mind I am a novice user and continue to struggle with access.

[ajetrumpet]

see if this helps you get started:

http://www.access-programmers.co.uk/...ighlight=field

[windwardmi]

I'm Still confused. It did not help. Let me break it down. I do not have much knowledge in VB so I will try to explain what I need.

1- Form Project Details has combo box for "Customer Contact" selected from column 2 of a qrery builder query.

2-I want an additional combo box just below on form and auto filled from column 3 same query. Column 3 is Customer Contact Mobile"

In the future I would want other info pulled like Email Address, etc. I know I can do this manually for all boxes but I want to save some time.

Any help in expaining this is appreciated.

[ajetrumpet]

you may want to consider hiring someone for a short project.

if you want to post what you've got, I'm sure one of use can assist pretty quickly for you.

[windwardmi]

I'll keep looking for the answer. I'm hoping to learn more as i proceed. Mean time I will get the project up to where I need to hire someone.

[ajetrumpet]

I'll keep looking for the answer. I'm hoping to learn more as i proceed. Mean time I will get the project up to where I need to hire someone.

I asked if you could upload it simply because this is a beginner type question (which i know you are, as you said). Today I did not have a lot of time to browse the forum and I may have answered you without the time to do so. If so, I apologize.

1- Form Project Details has combo box for "Customer Contact" selected from column 2 of a qrery builder query.

2-I want an additional combo box just below on form and auto filled from column 3 same query. Column 3 is Customer Contact Mobile"

So by column 2, you mean the second field in the statement?

and column 3? you want that filled, or you want a box filled AFTER you select a value from it? and is column 3 field #3 in the statement?

[windwardmi]

Misunderstood last post. Apologies.

I uploaded pictures of the Project Details Form and qry built for CUSTOMER CONTACT info I want.

Presently in Project Details Form the combo boxes for Customer Contact and Customer Contact Number are populated from dropdown list of combo box. Dropdown list comes form simple query of Contacts table.

I'm looking for simple code to populate combo boxes following Contact Names

i.e.: After placing John Doe in combo box from dropdown list for Customer Contact the next combo boxes on the form should auto fill with his details as applicable. Address, phone numbers, position, etc.

Do I need to creat a separate query? No problem there. But then what will be the code for subsequent dependent combo boxes?

[windwardmi]

I found a clear answer on another Forum. no VBA code is needed:

Assuming the name of my combo box is CustomerContact and the name of your text box for the telephone number is CustomerContactNo.

Also assuming the combo box row source is 3 columns
ContactID, Contact, TelNo.

ContactID is column 0
Contact is column 1
TelNo i column 2

The text box CustomerContactNo control source is
=[CustomerContact].[Column](2)

The test box is basically saying "Look in this combo box and find the value in the column noted and put it here"