Search results

This works just fine. What about if the textbox on the form references a record textbox of, for example, a keyword. It is showing up as the keyword-id (as a number). I don't want it to show up as a number, I want it to show up exactly as it is on the form. help.

I have created a form where the user selects two combo boxes, and the resulting records show up in the fields below. I want to create a report that reads off this form LIVE including what was selected from the combo boxes. Also, I have not used any queries for this, and I would prefer not to...

I think this may be quite easy but I have a form that is based on a search result. I want the user to be able to hit a button to print the form with the fields (and what's in the combo boxes) that he/she has selected. It seems easy enough to make a form, but how to make a form based on the...

Hi I would like to have a text box where you type in a keyword. Since there may be more than one result, I would like the results displayed in a combo box. I then would like the user to select from the combo box which record to display in the fields below. I have managed to do this fine...

Rich-O, I would like to do a similar sort of thing. I want to have text box where you can type in a keyword (I also have combo box doing the same thing but i would like to have two options for the users.) After typing in the keyword, I would like the results (which will be file names) to...

Malcy, Is there a way to do that with two cascading combo boxes? ie, if, after entering a value in the first combo box, it turns out no values in the second combo box, a msgbox pops up saying, "no values were returned" or something like that? I tried the code you used above and substituted...

Mile, What if I want to do the exact same thing, but instead of have the first selection being a combo box, I use a text box to do a search. I then want the results to show up in the second combo box to pick a selection. Does this make it a lot more complicated or can you simply change a few...

Mile, Thanks, that worked.

Mile, I used your example exactly of the [tblCars] and [tblModels] from a previous thread. So for the second combo box, I didn't have the extra columns in there. I tried the control source [for the text box]: =cboModels.model and it didn't work because I didn't have multiple columns...

CharityG, Thank you SO much, that has really helped me out.

CharityG, Is the datasource for the form the same as the recordsource? That's what I set to tblFile When I paste that code into the afterupdate field, I get an error that says: "Data type mismatch in criteria expression" and this line is highlighted when I go to debug...

combo boxes - PLEASE HELP! I have created two tables: tblDept and tblFile I have made two combo boxes based on these tables; When you select a department from the first combo box, the second combo box is filtered based on the department selection. After selecting the two combo boxes, I...

After I have got the 2 cascading combo boxes working, I want to display the fields in a "subform" based on the second combo box selection. How do I do this?

I have actually read the article "Cascading lists for Access Forms" and I downloaded the examples. However, it shows me how to get the two combo boxes working, but not how to display the records from the second combo box in another form or in a subform below the combo boxes. What is the...

sorry i had to make a new database because it was way too big.

Okay here it is. Sorry it's a bit messy, it's getting rather complicated. The form I am trying to get to work is called: "frmresultsdepttest" Combo box 1 is called: Comboseldept Combo box 2 is called: Comboselfile I have made a query called "qryresults" which can be used if needed...

I can not get cascading combo boxes to work. I have looked at many different examples but none of them seem to work for me. I want to have one combo box where you select the department. The second combo box selection will be filtered from the first combo box. The second combo box will have...