Recent content by Hibba

Thanks, I'll take a look. And yes, I need to learn about a lot of things...

I have a form with 6 combo boxes. All the combo boxes will change rowsource value depending on what value is in the first box, which is a number field, so always a number. I used the code builder to do this: Private Sub Form_Current() If Me.Cabin.Value < 10 Then Me.Skill_1.RowSource =...

Also, in the VB, how mighht I "change the value of the unbound combo box" I need a good reference for syntx in this stuff...

Hmm...not really. I want the Name to be the value in the table. Basically, if the form is not filled out, you choose the ID, if it has an ID, I want to see the Name. Since I see the Name, there is already a value for that field, but to change it I would want the drop down of ID. Get it?

How can I change the value of a combo box on exit. I want it to switch from ID to Name. This we I can input id (faster) and it can then show be name. Also, I would need to be able to choose Ids from the drop down as well, for future changes

Attached is what I have. the skills 1-6 are what I had, and the skill_id at the bottom is what I am working with. I have already found a few bugs I need to work out. For instance if you lookup to a specific record, then it will show all the skills (because i have that set as the default...

Scratch that, bad stuff leftover from doing something before... Now, what I would really like to do is have the combo box to show the skill name after I select the skill id and also have the skill name be sent to the table

Ok, GREAT, this is starting to work. Now, when I click in the Skill ID, it does not select it in the combo box, it just goes back to being blank. Also, I am going to do this action 6 times in my form, so do I need to put in different code for all 6 combo boxes?

Ok, cool, I was right on with that one. Now, would I do the same for numberfield and combo? Replacing numberfield with the actual name of that field? Thanks, you deserve a raise!

Ok, I understand that, put I will need to change things, correct? Example: NumberField should actually say what the integer field is called. Also, do I leave "Select SkillID From LowerTable Order By SkillID" just like it is or do I need to do some adjustment, like brackets and stuff.. Thank you!

Sorry, I'm pretty new to coding in Access, so this doesn't make clear sense to me. I am assuming that I use the code you have to derive my answer, and not just copy paste to the expression builder... Let's pretend I'm stupid (pretend, ha)

Ok, not too familiar with access syntax, so would I chane what you wrote to something like this: If Me.[Cabin] < 10 Then Me.[Skill Code].RowSource = [Lower Skills]![Skill_ID] Else Me.[Skill Code].RowSource = [UpperTable]!{Skill_ID] End If So [Cabin] is the name of the integer box, and...

If it's really that easy, I'm going to cry...

How can I update a combo box on my form to show one of two tables, depending on what number the user enters for the first field (integer) So something like an IF statement for the combo box: If number field <10, show lower table in combo box. If number field >10, show upper table in combo box...

I actually don't use "Name" I just used that in the forum to make it clear. My field names are called Skill and Skill_ID.