Search results

Well, now I have another problem which I cant find a solution. I have a two forms Form 1 and Form 2. In form 1 I have a combo list ExceptionsList. When I click on a record of the combo box ExceptionsList it opens Form 2 and passes the value to combo box FundIDCb. I used the FundIDCb default...

Cool guys.. it works now.. Thanks for the lesson. Where should I send the beers? Jose

John, How can I avoid the window message alerting about updating 1 row appearing? Thanks Jose

Guys, Thanks for your help. I think I will try both of them just to learn how both solutions work. Missingling, If I typed something in the textbox, does it get recorded in the table bound to the textbox? Jose

John, Thanks for your help. I used a text box linked to the combo box including Dlookup in the data control source and i get the field i wanted in my form from the table. The problem I have now is that I cant type any information on the text box. Do you know what I should do to be able to type...

John, thanks for your message. It was useful but I dont get the results I want to. Let me give you an example. In one of the columns of my combo box I have record IDs. The combo box has been created using a query. This query has been created using a table called "DailyPrices". If i clicked in...

Hello, I have a combo box with three fields: ID, Funds, Exceptions. These fields are linked to a query and the query has been created from a table called "DailyPrices". I would like to use the ID record from the Combo box to search for it in the table "DailyPrices" and provide me the information...

Bob: Thanks for your help. I am using a value list for my combobox as you can see below. Basically the idea is to choose the text ( Example "0.5%" or other ) which is the first column but I would like to pass as criteria the numbers ( Example 0.5)which are on the second column. This second...

I am really sorry but I dont know too much VBA. How can i get a combobox.text? and what is a setfocus? Thanks for your help J

Nope sorry. I am trying to use a combobox to pass criteria to a query.. nothing to do with reports.. sorry and thank for your help J

Hello, I have created a query with fund prices and fund prices variances and I am using a combo box to set up certain criteria in the query. The idea is that a user can select to see funds whose prices have varied 0%, 0.5% etc... This is my query: SELECT FundPrices_Qry00.Date...