Cascading Combo Question

[brsawvel]

If I have one combo box that displays values from a primary key field (fld1) in a table, how can I set the second combo box to automatically display whatever is in the second field (fld2) of that same record?

 

[Rabbie]

There are a lot of posts about this on this forum. Use the Search facility

 

[brsawvel]

I did a search earlier and I saw plenty of cascading posts where someone wanted to narrow their search in cbo2 based on their selection cbo1 (I was one of them), but this table is the other way around where I want the fld1 selection in cbo1 to display (not give options) fld2 of that same record in tbo2.
I'm guessing I could use the same cascading code to narrow the search, but how can I have the result automatically display in tbo2?

 

[boblarson]

Why would you want a combo to display the second field? It should be a text box actually. And for that you can put in the combo box's After Update event:

Me.YourTextBoxName = Me.YourComboBoxName.Column(1)

 

[brsawvel]

Thanks for the help. That was it.

My post must've been confusing, but I knew the second box had to be a textbox -

.....where I want the fld1 selection in cbo1 to display (not give options) fld2 of that same record in tbo2.

 

[Rabbie]

If I have one combo box that displays values from a primary key field (fld1) in a table, how can I set the second combo box to automatically display whatever is in the second field (fld2) of that same record?

I think it was the wording second combo box that mislead me.

My post must've been confusing, but I knew the second box had to be a textbox -

Seems the telepathic link was not working properly

 

[brsawvel]

My apologies. I must be dislexic or something like that.