Search results

I need the cbo to show them as Months and also the query needs to show them as months.

That works well until it hits my table because it is trying to store it as text for some reason and gives an error message that incorrect values are trying to be input. I have both my main table and cbo table month fields set to date/time format with mmmm as the format. Any ideas on why this...

What would the display mask look like? I have the month and year as 2 seperate fields on the table and query but coincide with one another as far as entry goes.

What happens if the year needs to be 2004 or 2006?

No because I have another cbo with the year.

I have a combo box that contains the months. They appear in month order on the form but when I query, they are in alphabetical. How can I get this to be in month order on the query?

I would like my form field to populate based on what the user selects from 2 combo boxes I have. I have a table set up with Region, Position, and Name. I would like when the user selects for example Eastern for the region and President for the position that John Smith would auto populate in...

I do have a grid of titles. In my table I have 3 fields. One for region, one for title and one for name. So on my form when the user selects the correct combination I would like the name to appear. What kind of code do I need to use to get this to happen?

Is there a way to make a field on a form dependent on what the user selects from 2 other cbo? By that I mean I would want the user if they selected in cbo1 Easter and they select cbo2 Regional President in the form field I would want it to auto return the name John Smith because in my table he...

Thanks. Any help Pat????

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?

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

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.

What do you mean contactenate them on the fly?

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...

That will require the user to select John Smith from the combo box 3 correct. I want it to automatically populate his name in the field.

How can I get it so when the user selects choices from the 2 other combo boxes, it will know that John Smith corresponds with the Eastern (cbo1) and Regional President (cbo2) selections?

I have a list box in a form that controls the query results which will display a name when a certain region is selected. I would like for this to be incorporated into my form so when the user selects the Eastern region for example, John Smith will automatically be returned in the filed on the...

Nevermind. I got it. Thanks for all of your help and I apologize for being so slow today!

What do I need to put in the query to make it point to that?