Field auto populates

[jamphan]

What is the best way to get a field to automatically populate on a form when the user select criteria from 2 combo boxes. For example in cbo1 the user select Eastern and cbo2 the user selects Regional President. How can I get in a seperate field the name of the Eastern Regional President to populate?

 

[KenHigg]

I would simply store them as seperate flds and concatenate them on the fly whenever needed...

Or in the cbo2 after update event, do something like:

me!myfld3 = me!mycbo1 & " " & me!mycbo2

 

[jamphan]

What do you mean contactenate them on the fly?

 

[KenHigg]

Just a big word for joining or combining them, say in a query or in a form...

Like:

fieldname1 & " " & fieldname2

Make sense ???

 

[jamphan]

I understand the concatenate part. I am a little unclear where I need to put the concatenation and how to get it to sink up with field 3.

 

[KenHigg]

Simply don't have a field 3. If / when you need the complete title, combine them in the query or where ever you may need...

 

[jamphan]

I need the result to show up on the form and also populate the table my form is linked to.

 

[KenHigg]

Then maybe the second option in post #2 from above would work...

 

[jamphan]

I believe I have misled you with my post. I don't want to combine the 2 fields, I want it to return John Smith who is the Easter (cbo1) Regional President (cbo2). It would need to use the 2 cbo to query to know that John Smith is the Eastern Regional President. Any idea?

 

[KenHigg]

Oh, I see...

Maybe you'd be better off to wait for Pat, she's much more experienced and she's making her rounds so she would most likey shoot holes in any of my suggestions

 

[jamphan]

Thanks.

Any help Pat????