Search results

Hello again all. At long last i got it to work :D the code i was entering into the criteria field was wrong, it now works with this: Like "*" & [Forms].[ViewCableCardForm].[Combo29] & "*" I got the information from this really good website: http://allenbrowne.com/ser-62.html I would just...

I understand what you mean but using the immediate and entering ?[Forms]![ViewCableCardForm]![Combo29] it returns the correct value. So i dont need to specify which column it is. If i load the form first, select a value in the comobox, then open the query in design view and enter this in the...

Hmm im not sure what you mean but yes the query(tblCableCardQuery) has the criteria in it under CableInstaller field. The form(ViewCableCardForum) has the combo box(combo29), the combo box gets its data from a table(tblEmployees). when the combo box selects a name, the ID number of the...

the vb code for the button is: Private Sub Command32_Click() On Error GoTo Err_Command32_Click Dim stDocName As String stDocName = "tblCableCardQuery" DoCmd.OpenReport stDocName, acPreview Exit_Command32_Click: Exit Sub Err_Command32_Click: MsgBox Err.Description Resume Exit_Command32_Click...

yes it is a command button on the form which when pressed views the query as a report. It doesnt show anythign when i click on it. How can i get the form to load then insert the [Forms]![ViewCableCardForm]![Combo29] into the criteria of the CableInstaller field?

yes it works :D but now, on the form, i cant select the Preview button to display the filtered query. I can change the combo box number and then run the query and it filters everything apart from what i have in the combo box, exactly what i wanted, but i cant preview the query from the...

Yes but i have to remove the [Forms]![ViewCableCardForm]![Combo29] from the criteria box to allow me to see anything in the Form. Once that is removed the combo box works fine.

Its there because I copied it form the last post, i didnt include it in the query.

I then tried replacing the value in the CableInstaller Criteria box with just the ?[Forms]![ViewCableCardForm]![Combo29] but now when i click on the form it doesnt show anything, its totaly grey.

I didnt know what the immediate window was but i do now after a google;) I entered ?[Forms]![ViewCableCardForm]![Combo29].[column(0)] into the window and pressed enter, it gave this error: runtime error 438 object doesnt support this property or method. I tried...

There are no parameters. Yeah i dont know why it is asking for it via a message box instead of taking the value from the combo box. The actual combo box has no influence on the query, it doesnt matter what i put in the combo box. the message box that pops up is what decide's what records are...

I have tried it both ways(open and closed) but i doesnt make a difference, it still asks for [Forms]![EmployeeForm]![Combo22].[Column(0)]) to be entered.

To input the ID number from the combo box i just go to the query and into design view, i then click on the CableInstaller Criteria box and right click it and click Build, i then select Combo22 from the form list. Which comes out as: Forms![ViewCableCardForm]![Combo29] the way i see it, if i...

Alisa, I have changed it to the ID of the employees rather than there actual names to avoid the error of two names being the same but..as before, instead of the name(ID) being selected from the combo box it is popping up a msg box and asking the ID to be typed in. It works when i type in the ID...

Ah, yeah i did think of that but i thought i would fix that later, but since you have pointed it out i will change it. The cableInstaller is the field i want filtered depending on the name. The cableinstaller field is inputed from another form and the data comes from a seperate employee table...

Yes i have a main query which holds all the information and has no filters or anything in it, then there is 3 querys that have seperate filters in them for each form and task. They get there information from the main query. The 3 querys have each got a filter for different tasks, like the one...

SELECT EmployeeQuery.Installer, EmployeeQuery.Completed, EmployeeQuery.HoursToComplete FROM EmployeeQuery WHERE ((( EmployeeQuery.Installer)=[Forms]![EmployeeForm]![Combo22].[Column(0)]) AND (( EmployeeQuery.HoursToComplete) Is Null));

I seems to be kind of working by using "[Forms!EmployeeForm!Combo22].[Column(1)]" but instead of the name being selected from the combo box it is popping up a msg box and asking the name to be typed in.

The Form(EmployeeForm) which has combo box(Combo22) has the record source of the query(EmployeeQuery) that I am trying to filter. Thanks Dom

Thanks for the reply Alisa but i dont understand what you mean. Should i change the code to "[Forms!EmployeeForm!Combo22].[Column(1)]" Thanks Again Dom