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!

Does anybody know what the code is for AddItem? Thanks

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

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

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.

Is it possible to use Combo Boxes (i.e. get them to update) in a read only form? I have them in a form that has edit capabilities and when you close the form it says changes were not saved because the primary key does not allow duplicates (something like that). I don't want changes to be...

Hi all, I have a form with a table as a source. On the form I have 2 combo boxes. Is it possible for me to restrict what shows up as options in one combo box based on the choice in the first combo box? I.e. use one to filter the other. Thanks for the help.

Early Morning question to start off the day! If I have a table with an AutoNumber Primary, and two other columns with text values, can I take a second table compare two of it's columns, compare the text with the main tables two columns and put that particular combinations Primary # from the...

Hi all, I have a form being used as an input form. I have a few fields originating from the forms record source. One of these fields is a combo box. I am wondering how I get two of the other fields to update based on the choice of the combo box? I.e. 73, orange, and blue are an entry...

I have a general question on the Northwind database example. If you click on the Categories button off of the Switchboard, the Categories table opens. When I look at this form in design view there is a subform. I want to know how they get the subform to update with the correct table, when a...

I keep getting a syntax error with this line of code. Any suggestions? DoCmd.ApplyFilter([FruitFilter],[Forms![Fruits]![Fruit]= "Apple")])

Hi all, I currently have a form with 2 subforms. These subforms are opened based on which check box is selected. What I am looking to do now is add another set of check boxes that will filter these subforms based on which is checked. Ex. check box group 1 ( Xbox, Gamecube, PS2) check...

Hello all, New to the tek-tips site and Access, but looks pretty useful. Here is what I am trying to do at the moment.... I want to create a form with essentially 2 option groups and a command button. The choice of one option group will determine which table to use, and the choice of...