Hello there!

(IMG:style_emoticons/default/iconfused.gif) I have a question...how can I populate a texbox on a form based on the choice of two comboboxes? So far I have done this using only combo boxes, but I want it to populate in a textbox. Any help would be greatly appreciated,

Thanks in advance

~TechSteff

This post has been edited by TechSteff: Nov 5 2010, 12:49 PM

so, you have an unbound textbox that you want to take information from 2 different comboboxes. what I would suggest is actually using 3 textboxes even if you have to hide them. Reason being if you use 1 and you concatenate the combobox1 value and combobox2 value when would you do this in code? After Combo2 onclick? how would you check if combo1 had been done already. With a textbox for each you can check to make sure they are both not empty and then your third textbox would simply be text3 = text1 & text2 you can put in spaces or commas or semi colons or......

Just my thoughts

Hi

You're question is a bit vague (IMG:style_emoticons/default/iconfused.gif)

Could do with more details from you as to exactly what you want for someone to be able to give you an answer (IMG:style_emoticons/default/wink.gif)

Thanks for the reply, but I didn't explan the situation well enough. I have two combo boxes and based on the value of two combo boxes I would like to a query to populate the textbox, for example if Combo1. is Lastname and Combo 2 is Name I want a query to populate the textbox with that persons birthdate something like that...

just to clarify..

Your query would look like this very generic example. and have that as the source for your text box ??

select fields from table where fieldlast = forms!combobox1 and fieldother = forms!combox2'


IF yes, could you tell us the name of the table and the name of the fields ?

Hi,


Pardon me for jumping in but that description could still use a little more detail. In fact, it's quite possible that we might recommend you to change your form's design. For example, let's say that the first combobox is showing "Smith" and the second combobox is showing "John." What if you actually have more than one "John Smith" in your database? Who's birthday would you want to show up in the textbox?

Just my 2 cents...

EDIT: I guess the point I am trying to make here is that we need to get you into the habit of using Primary Keys. They are the only way to ensure we are working on a specific record.

Cheers

This post has been edited by theDBguy: Nov 5 2010, 01:52 PM

Thanks for your input guys, but I think I figured it out. (IMG:style_emoticons/default/thanks.gif)

Hi,


I hope you are not just saying that. If you truly found a solution, we are happy for you.

I was not trying to scare you away, so I apologize if my post was taken that way.

We wish you the best with your project.

Cheers (IMG:style_emoticons/default/cheers.gif)

Hahahaha No I figured using a combobox could get the job done ;-)

Thank you! (IMG:style_emoticons/default/thumbup.gif)