update textbox based on combo box selection

[slavisa]

I have one questions about my database. I have made couple of tables and some forms and a report.

I have a table called CourseNumbers with 2 fields, one is the coursenumber (ex. CI-120) and other is the description of that course (ex. xxxxxx)

Now in my form i have a combo box of coursenumber fields where a person can select which course number they want, then that selection is written in the course information table under coursenumber. what i want is when someone selects this course #, the description field will be filled in automatically, and the info from this txt field will then be written into the course information table under the field name description where all the data will be held.

Im not sure how i can do this and if its going to work.

Or if u can help me lets say, have a combo box with all the Numbers, when that is selected in the text box i want it to display the text description of that coursenumber.?

right now i have it where the combo box is selected and the text box a person has to write info in it and then that info is store in course information table.

thanks in advance
slavisa

[missinglinq]

I'm a little confused as to exactly what it is you're trying to accomplish here, but in order to have a combo box that retrieves the course descriptions:

1) Create a form using the table CourseNumbers as the Record Source.
2) Goto the Field List and drag the CourseDescription field onto the form
3) Place a combo box on the form
4) Select "Find a record on my form based on the value I've selected..."
5) Next
6) Select CourseNumber
7) Next
8) Size the Combo box column
9) Next
10) Name the combo box
11) Finish

Now the user can use the dropdowwn arrow of thecombo box to retrieve the course description or simply start typing the course number in and the combo box will start to autocomplete the entry. When the correct entry is found hit <Enter> and the course description should be retrieved.

Good Luck!

I have a table called CourseNumbers with 2 fields, one is the coursenumber (ex. CI-120) and other is the description of that course (ex. xxxxxx)

Or if u can help me lets say, have a combo box with all the Numbers, when that is selected in the text box i want it to display the text description of that coursenumber.?

[JConsulting]

if your combo box displays both the course and the description, and if your combo box is bound to the course number field, and you want to "auto-populate" the description on the same record,

In the After_Update event of your combo box

me.description = me.mycombo.column(1)

column 0 being the far left column (which I Assume is the Course number) and column 1 being the description.
J

[ncsuwolfe]

I wanted to bring this back to the top, as it exactly pertains to what I am needing help on, but it did not help me

I have two records in a form that are from the same source table. I want the second field (genus and species) to populate when I select the first field (which is the species common name).

Neither field,I should add, is the master key for the form. Rather the unique id is the observation number. Can someone help?

I feel like the suggestion from missinglinq is getting me close, but the combo box will not allow me to perform the lookup from the source table, only from the table that is the one I am trying to populate with the form.

[vkong85]

i think i know what you are trying to accomplish because i've done the same. what i did (through some struggle) was figure out how to use a DLookUp. Basically its a command that tells the computer to lookup a certain value from a field given a certain criteria.

So if ure master field has the course number and the description then it will match the description to the course number and all you have to do is tell the computer where to send the course description and in turn it will fill that value with the description.

Be aware that DLookUp can be tricky but it is extremely useful... there are also plenty of posts concerning DLookUp on the forum.

[ncsuwolfe]

Okay, I have been playing with this DLookup for awhile. It looks like this

=Dlookup("[SpeciesScientificName]","CtblSpecies","[SpeciesCommonName]='" &Forms!EOIDForm!SpeciesCommonName & "'")

I have it located in the after update portion of the SpeciesCommonName Combo box. When I put the form into data entry mode, it lets me select a combo box option, just fine, but then it doesn't do anything. No Error messages or anything?

My question, and it might be a stupid one, is how does this string tell Access to write the lookup value into the Text box on my form for SpeciesScientificName? I feel like there is nothing directing to program to do something with the lookup value once it is obtained? Thanks for any help!

I tried out the various components in the Immediate window, with hard coding, and everything seemed to work fine. So, I think I have the expression and domain correct. However, I worry that the criteria is all messed up.

Wolfe

[JConsulting]

Okay, I have been playing with this DLookup for awhile. It looks like this

=Dlookup("[SpeciesScientificName]","CtblSpecies","[SpeciesCommonName]='" &Forms!EOIDForm!SpeciesCommonName & "'")

I have it located in the after update portion of the SpeciesCommonName Combo box. When I put the form into data entry mode, it lets me select a combo box option, just fine, but then it doesn't do anything. No Error messages or anything?

My question, and it might be a stupid one, is how does this string tell Access to write the lookup value into the Text box on my form for SpeciesScientificName? I feel like there is nothing directing to program to do something with the lookup value once it is obtained? Thanks for any help!

I tried out the various components in the Immediate window, with hard coding, and everything seemed to work fine. So, I think I have the expression and domain correct. However, I worry that the criteria is all messed up.

Wolfe

I think you need to open your own question...you've hijacked someone else's thread. You can link to this thread as a reference...but you really need to open your own.
J