Search results for query: *

How would I set a text box value to the item not selected in a 2 choice combo box. I.e. if index 0 is selected, the text box should have the value at index 1 of the combo box. thanks again!

I found it about 2 minutes after I posted. Thanks for the quick responses though!.

Does anybody know what the code is for AddItem? Thanks

bump for more suggestions.

Hi all, I have a series of combo boxes on a form that I wish to be dependent on each other in this way. 1. C1 - no dependancies 2. C2 - list is filtered by option in chosen in C1 The above part I have working. 3. C3 - I want the combobox list to have 2 values, these values need to be the...

Components.FI='A'" I put this into the WHERE statement of the DoCmd line and I get this error. Syntax error (missing operator) in query expression 'Components.FI='A' so it's getting closer!

well this is my code: [[Components].[FI]="A"] Components is the table FI is the column inthe table A is the value I want This is the error: can't find the field '|' referred to in your expression. It was working when I had a macro, but i wanted to eliminate the macros and go to code.

I know which argument it is, I am trying figure out what the code would be in this argument. Thanks.

I have a form with an action button on it that when clicked opens another form. I wish to apply a filter to the opened form. what would the code be in the DoCmd.OpenForm to select those records where the value of FI in the table Components is equal to A. I believe I have to apply the filter...

I figured out what I was doing. Added the other columns to the combo box and hid them, then set the value of the text box equal to a value in one of the hidden columns. Thanks for the help!

That is the SQL code that is in the SQL view of the query. Do you mean something else?

SELECT [Fruit Relationships].[Fruit Relationship] FROM [Fruit Relationships]; this is what is in the rowsource property, with name substitutions. HTH, see you in the AM

Think I should clarify. The combo box only has one column which I use as a query to determine the value of the text box. The text box does not equal the value of the combo box. ex. Fruit1_Fruit2 | Fruit1 | Fruit2 | Fruit3_Fruit4 | Fruit3 | Fruit4 | If my combo box has the option...

Ok, I will try that, but the question is where do I put that line of code? Before Update, After Update, Default value etc. The code is helpful but I also need the location to put it! thanks!

It's value is chosen based on the users choice in a combo box. I could not find a way to set the value of a text box based on a choice in a combo box. So i used a list box so I could utilize the RowSource property. Is there an easy way to set a text box to a value based on the combo box choice?

bump

Which event do I place this is? Before Update, After, etc...

Hi all, I have a list box with a single entry. How do I set the list box so that it chooses that value without having to click on the list box? Thanks.

Figured out a way aroud this also. I removed the Control Source for the objects. The RowSource still populates the object, and with no control source the form doesn't try to edit the tables.

Play with the Value property. Didn't see a Value listed in the properties window. I found a way around it by making the fields list boxes as opposed to text boxes. Only problem is no wrap around text on the list box :(. It's like cutting your distance in half to a goal, no matter how many...