Select from drop down to populate three fileds in a table

[LindaRuble]

Hello,

I would like to be able to select a value from a drop-down and by doing so be able to populate three fields in a table.
Any help would be appreciated.



Thanks

Linda

[orange]

Just curious, why would 3 fields in the same record of a table have the same record source for data values?

I'm trying to "see" what your table may look like, and how 3 different fields in a record would get similar values.
Please describe WHAT you are trying to do in business (not access) terms.

[LindaRuble]

Hi,

OK, I guess I was not clear about what I wanted.

I want to be able to select a value from a drop-down and by doing so, be able to select not only the value in the drop-down but also two other "different' values associated with the record set chosen. Once selected, these three different values go into another table that will eventually be used to generate a report.

In other words, I want to simplify filling out a form by eliminating two fields that need to be filled out. So by making the drop-down selection you are actually selecting three values -- the one from the drop-down and two other related values.

The table "ClientDiv" that the values will be taken from have the following columns: "Client_Division", "Priority", "Region_Div"

In the drop-down the user will be selecting values from "Client_Division" but will also automatically be choosing "Priority" and "Region_Div" of that record set from table "ClientDiv" to be inserted into the table, "RTIClientTracker"

Hope this helps

Thanks

Linda

[orange]

I'm not understanding your requirement. And you haven't expressed WHAT you are trying to do in 'Business" term.
So I am guessing --
I suggest you look up Cascading Combo boxes and see if that's close to what you are talking about.

Here are 2 free video tutorials.
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

[LindaRuble]

I'm not understanding your requirement. And you haven't expressed WHAT you are trying to do in 'Business" term.
So I am guessing --
I suggest you look up Cascading Combo boxes and see if that's close to what you are talking about.

Here are 2 free video tutorials.
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

Hi,

I thought that 'Business" terms meant non-tech terms. In other words, just explain what you want to do. What I want to do is to simplify filling out a form by reducing the number of fields to fill out. You would select one value in a drop-down but be getting two other different values at the same time in the background.

I don't thing cascading combo boxes would work for me since I only want to see one drop-down control on my form (not three).

I've already considered cascading drop-down combo box but before I submitted my question to this forum.


Maybe the answer is a special SQL statement for the row source.

Any help would be appreciated.

Thanks

Linda

[alansidman]

If I am reading this correctly, I think this is what you are trying to accomplish.

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

Alan

[orange]

You could be right Alan - I was confused with the request and description.
Autofill may be the answer -- I hope so.

[LindaRuble]

If I am reading this correctly, I think this is what you are trying to accomplish.

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

Alan

Thanks,

This looks promising and sounds like what I need. Is it possible to direct me to a link where I can download an example of a program that does "Auto Fill" that saves the selection and related info from one table into another table? (and not just displays related info on a form). Examples really help me understand what is happening. I tried looking for an example myself but have not been successful. I actually did download one example , however, it appeared corrupted.

Any help is appreciated.

Thanks

Linda

[orange]

There is a free video tutorial at
https://www.youtube.com/watch?v=rSPS24EfijI

[LindaRuble]

There is a free video tutorial at
https://www.youtube.com/watch?v=rSPS24EfijI

Hello,

Thank you very much for the link to the video tutorial. I tried to duplicate what was demonstrated in the video and I get the combo box to drop down but it fails to populate the other fields on the form and does not enter the data into the other table. I've tried several times and still no luck.

I am sending you an attachment of the project "database1.zip" so that you can see what I did. Please let me know where I want wrong.

Thanks

Linda

[alansidman]

As far as populating other fields, have you looked at this.

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

[orange]

I have looked at your database and do NOT understand your tables. They have exactly the same design?

In plain English, what do the 2 tables represent?
What is the purpose of the drop down?

In the example video, the presenter was using an Employee table and a Training table.
His form was based on the Training table and the form set up allowed him to fill in the EmpId, FirstName and LastName controls from the Employee Table.

[LindaRuble]

I have looked at your database and do NOT understand your tables. They have exactly the same design?

In plain English, what do the 2 tables represent?
What is the purpose of the drop down?

In the example video, the presenter was using an Employee table and a Training table.
His form was based on the Training table and the form set up allowed him to fill in the EmpId, FirstName and LastName controls from the Employee Table.

Thank you for your help. I have figured out what I needed to know.

Linda