Combo box changing text box values

[MikeEmerald]

Hi all,

Brand new to learning Access and im just after a quick help to get me started for most of what i need.

I have a table with the two following columns (Raw Material / CAS No)
In a form i currently have a combo box that has it's row source as

SELECT [Raw Material].[ID], [Raw Material].[Raw Material] FROM [Raw Material];

I then have a text box for the CAS No that i want to update to show the Cas for the selected raw material in the combo box.

Any help would be grand.



Thanks so much,

Mike

[andy49]

What other data is going on the form?

Pull all of these into a query in design mode then use

=cboRawMaterials.value

as the criteria

[MikeEmerald]

Hi Andy, thanks for replying. I'm really new to all this so i have attached a picture for me to understand your answer better.

I set up the query but seem to be stuck getting the combo box and text box's sorted.

Thanks for the help.

[andy49]

ok

try and create another combo box but see if it has three options at the beginning. One would be something like "find a record on my form based on the value I choose in my combobox"

[MikeEmerald]

No, just the normal two options available when i create another combo box

[andy49]

Does your form have any data being fed into it? Could you post a copy of your database online?

(Go advanced and zip it first?)

[andy49]

Had another think

Look for the on_change event of the combobox you are using and copy and paste the following code

Replace ComboName with the actual name of the Combo Box

All you need is:

Me.Filter = "ID = " & Me.ComboName
 Me.FilterOn = True

[MikeEmerald]

I can't upload because of works network restrictions. I will try to be more descriptive with my issues.

Please see pictures.

So my query works fine, it feeds the raw material into the raw material combo box on the form, however when i switch between test material 1 and test material 2 in the combo box, i would like the Cas No. text box to update with the cas no pulled from the query.

Is there something i need to put in the text box properties, a macro or something.

Thanks for paitence

[andy49]

see post #7

Happy to help

[MikeEmerald]

Andy, think you was trying to solve different problem? My combo box works fine in selecting the material from the query, it just doesnt update the text box with the CAS No. for the selection.

[andy49]

Not at all Mike. Can you tell me if your form has a record source.

(in design mode go into properties of the form. It should be the top one)

And what is the control source of the textbox Cas No

[MikeEmerald]

No record source and there is no source for the text box

[andy49]

aha.

Do you have a table (or query) with all the details you need on the form including casNo.

If not, make one

[MikeEmerald]

Thanks for your help Andy, managed to sort it +rep