If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
I'm sorry L T, I only brought half of my brain in to work today. The other
half is home asleep. It has to be like a where clause without the whe "[MyField] = '" & [Forms]![Empl Forms]![Combo19] & "'" Where [MyField] is the field you want to filter on. Again, my apologies. "LT Larry" wrote: Same message W/out the = sign "Klatuu" wrote: Try taking out the = sign. In the filter property for the report [Forms]![Empl Forms]![Combo19] "LT Larry" wrote: Ok I am on the same sheet now Did as instructed but recieved the following message Syntax Error (missing Operator) in query expression'(In Filter:=[Forms]![Empl Forms]![Combo19])' "Klatuu" wrote: I don't understand what you mean by "I deleted the field value an re-inserted it " Open your query in design mode and delete any criteria in it. You want all the filtering done from the report. Am I correct in assumint that combo19 is a control on your form you use to look up a value? [Forms]![Empl Reports]![Combo19] should be in the Filter property of your report. "LT Larry" wrote: Klatuu I deleted the field value an re-inserted it but I still get the Combo Box when I ref the critera control [forms]![Empl reports]![combo19] Field Properties: under the lookup tab Display Control: Combo Box Row Source Type: Field List Row Source: [forms]![Empl Reports]![Combo19] Also where do should I put In Filter: =[Forms]![Empl Reports]![Combo19] Thank you for your patience "Klatuu" wrote: True is the same as Yes, sorry I used the wrong term. It is the programmer in me. True = Yes = -1 False = No = 0 Take the drop down out of the query. There should be no criteria in the query at all. In Filter: =[Forms]![Empl Reports]![Combo19] Try this, let me know how it works. "LT Larry" wrote: Klatuu The Filter Properties are Filter: Blank Filter On: No Order By: Blank Order By On: yes When I run the Query by its self I get a blank row with a drop down button in the name field. I hope thats what you were looking for I changed the Filter On: to yes and the report retrieves all the records in the query. I am working with Access 2000 and do not have the option to set the value to true "Klatuu" wrote: Okay, I still don't know exactly what the problem is, but here are a couple of things you can do. Post what you have in the filter property of the report, please. Be sure in your report you have the Filter On property set to true. Run the query stand alone, I mean without the form or the report open to see what result you get. We can make it work! "LT Larry" wrote: Klatuu I took the text off the end of the statement and the report is set up to filter not the query. It still is not working. When I run the query with the open form it is still blank. I also have a dropp down button in the name field of the query but when I select it the data filed is blank. Any suggestions: Thanks "Klatuu" wrote: LT, There are a couple of problems here. First, there is no [Text] property in VBA. That is VB. =[Forms]![Empl Reports]![Combo19] is the same as =[Forms]![Empl Reports]![Combo19].Value You also may want to take the filter criteria out of the query and put it in the report as the filter property. "LT Larry" wrote: Here are the steps I have already done: I have created an unbound form (Form 1) with an unbound Combo box (Combo19) containing Empl names.(control source is Employ tabl). On the form I have created a command Button to open a report (Report 1). I have created a query(Query 1) and in the last name field in have entered =[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using the expression builder I originally selected "value" in the last block but it did not work that is why there is the [Text] expression) I have create a report (Report 1) to open the Query. Problem: When I use the command button on the form to open the Report (After a name selection in the Combo box) the report is blank. I then created a command button to directly open the query from the form and it also comes up blank. But if I select a name from the combo box and manually open the query it works fine and if I manually open the report after maunaully opening the query the report works fine. I am completely puzzled???? Thanks in advance for any assistance |
#12
|
|||
|
|||
Same message W/out the = sign
"Klatuu" wrote: Try taking out the = sign. In the filter property for the report [Forms]![Empl Forms]![Combo19] "LT Larry" wrote: Ok I am on the same sheet now Did as instructed but recieved the following message Syntax Error (missing Operator) in query expression'(In Filter:=[Forms]![Empl Forms]![Combo19])' "Klatuu" wrote: I don't understand what you mean by "I deleted the field value an re-inserted it " Open your query in design mode and delete any criteria in it. You want all the filtering done from the report. Am I correct in assumint that combo19 is a control on your form you use to look up a value? [Forms]![Empl Reports]![Combo19] should be in the Filter property of your report. "LT Larry" wrote: Klatuu I deleted the field value an re-inserted it but I still get the Combo Box when I ref the critera control [forms]![Empl reports]![combo19] Field Properties: under the lookup tab Display Control: Combo Box Row Source Type: Field List Row Source: [forms]![Empl Reports]![Combo19] Also where do should I put In Filter: =[Forms]![Empl Reports]![Combo19] Thank you for your patience "Klatuu" wrote: True is the same as Yes, sorry I used the wrong term. It is the programmer in me. True = Yes = -1 False = No = 0 Take the drop down out of the query. There should be no criteria in the query at all. In Filter: =[Forms]![Empl Reports]![Combo19] Try this, let me know how it works. "LT Larry" wrote: Klatuu The Filter Properties are Filter: Blank Filter On: No Order By: Blank Order By On: yes When I run the Query by its self I get a blank row with a drop down button in the name field. I hope thats what you were looking for I changed the Filter On: to yes and the report retrieves all the records in the query. I am working with Access 2000 and do not have the option to set the value to true "Klatuu" wrote: Okay, I still don't know exactly what the problem is, but here are a couple of things you can do. Post what you have in the filter property of the report, please. Be sure in your report you have the Filter On property set to true. Run the query stand alone, I mean without the form or the report open to see what result you get. We can make it work! "LT Larry" wrote: Klatuu I took the text off the end of the statement and the report is set up to filter not the query. It still is not working. When I run the query with the open form it is still blank. I also have a dropp down button in the name field of the query but when I select it the data filed is blank. Any suggestions: Thanks "Klatuu" wrote: LT, There are a couple of problems here. First, there is no [Text] property in VBA. That is VB. =[Forms]![Empl Reports]![Combo19] is the same as =[Forms]![Empl Reports]![Combo19].Value You also may want to take the filter criteria out of the query and put it in the report as the filter property. "LT Larry" wrote: Here are the steps I have already done: I have created an unbound form (Form 1) with an unbound Combo box (Combo19) containing Empl names.(control source is Employ tabl). On the form I have created a command Button to open a report (Report 1). I have created a query(Query 1) and in the last name field in have entered =[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using the expression builder I originally selected "value" in the last block but it did not work that is why there is the [Text] expression) I have create a report (Report 1) to open the Query. Problem: When I use the command button on the form to open the Report (After a name selection in the Combo box) the report is blank. I then created a command button to directly open the query from the form and it also comes up blank. But if I select a name from the combo box and manually open the query it works fine and if I manually open the report after maunaully opening the query the report works fine. I am completely puzzled???? Thanks in advance for any assistance |
#13
|
|||
|
|||
Klatuu
The Filter Properties are Filter: Blank Filter On: No Order By: Blank Order By On: yes When I run the Query by its self I get a blank row with a drop down button in the name field. I hope thats what you were looking for I changed the Filter On: to yes and the report retrieves all the records in the query. I am working with Access 2000 and do not have the option to set the value to true "Klatuu" wrote: Okay, I still don't know exactly what the problem is, but here are a couple of things you can do. Post what you have in the filter property of the report, please. Be sure in your report you have the Filter On property set to true. Run the query stand alone, I mean without the form or the report open to see what result you get. We can make it work! "LT Larry" wrote: Klatuu I took the text off the end of the statement and the report is set up to filter not the query. It still is not working. When I run the query with the open form it is still blank. I also have a dropp down button in the name field of the query but when I select it the data filed is blank. Any suggestions: Thanks "Klatuu" wrote: LT, There are a couple of problems here. First, there is no [Text] property in VBA. That is VB. =[Forms]![Empl Reports]![Combo19] is the same as =[Forms]![Empl Reports]![Combo19].Value You also may want to take the filter criteria out of the query and put it in the report as the filter property. "LT Larry" wrote: Here are the steps I have already done: I have created an unbound form (Form 1) with an unbound Combo box (Combo19) containing Empl names.(control source is Employ tabl). On the form I have created a command Button to open a report (Report 1). I have created a query(Query 1) and in the last name field in have entered =[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using the expression builder I originally selected "value" in the last block but it did not work that is why there is the [Text] expression) I have create a report (Report 1) to open the Query. Problem: When I use the command button on the form to open the Report (After a name selection in the Combo box) the report is blank. I then created a command button to directly open the query from the form and it also comes up blank. But if I select a name from the combo box and manually open the query it works fine and if I manually open the report after maunaully opening the query the report works fine. I am completely puzzled???? Thanks in advance for any assistance |
#14
|
|||
|
|||
Try taking out the = sign. In the filter property for the report
[Forms]![Empl Forms]![Combo19] "LT Larry" wrote: Ok I am on the same sheet now Did as instructed but recieved the following message Syntax Error (missing Operator) in query expression'(In Filter:=[Forms]![Empl Forms]![Combo19])' "Klatuu" wrote: I don't understand what you mean by "I deleted the field value an re-inserted it " Open your query in design mode and delete any criteria in it. You want all the filtering done from the report. Am I correct in assumint that combo19 is a control on your form you use to look up a value? [Forms]![Empl Reports]![Combo19] should be in the Filter property of your report. "LT Larry" wrote: Klatuu I deleted the field value an re-inserted it but I still get the Combo Box when I ref the critera control [forms]![Empl reports]![combo19] Field Properties: under the lookup tab Display Control: Combo Box Row Source Type: Field List Row Source: [forms]![Empl Reports]![Combo19] Also where do should I put In Filter: =[Forms]![Empl Reports]![Combo19] Thank you for your patience "Klatuu" wrote: True is the same as Yes, sorry I used the wrong term. It is the programmer in me. True = Yes = -1 False = No = 0 Take the drop down out of the query. There should be no criteria in the query at all. In Filter: =[Forms]![Empl Reports]![Combo19] Try this, let me know how it works. "LT Larry" wrote: Klatuu The Filter Properties are Filter: Blank Filter On: No Order By: Blank Order By On: yes When I run the Query by its self I get a blank row with a drop down button in the name field. I hope thats what you were looking for I changed the Filter On: to yes and the report retrieves all the records in the query. I am working with Access 2000 and do not have the option to set the value to true "Klatuu" wrote: Okay, I still don't know exactly what the problem is, but here are a couple of things you can do. Post what you have in the filter property of the report, please. Be sure in your report you have the Filter On property set to true. Run the query stand alone, I mean without the form or the report open to see what result you get. We can make it work! "LT Larry" wrote: Klatuu I took the text off the end of the statement and the report is set up to filter not the query. It still is not working. When I run the query with the open form it is still blank. I also have a dropp down button in the name field of the query but when I select it the data filed is blank. Any suggestions: Thanks "Klatuu" wrote: LT, There are a couple of problems here. First, there is no [Text] property in VBA. That is VB. =[Forms]![Empl Reports]![Combo19] is the same as =[Forms]![Empl Reports]![Combo19].Value You also may want to take the filter criteria out of the query and put it in the report as the filter property. "LT Larry" wrote: Here are the steps I have already done: I have created an unbound form (Form 1) with an unbound Combo box (Combo19) containing Empl names.(control source is Employ tabl). On the form I have created a command Button to open a report (Report 1). I have created a query(Query 1) and in the last name field in have entered =[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using the expression builder I originally selected "value" in the last block but it did not work that is why there is the [Text] expression) I have create a report (Report 1) to open the Query. Problem: When I use the command button on the form to open the Report (After a name selection in the Combo box) the report is blank. I then created a command button to directly open the query from the form and it also comes up blank. But if I select a name from the combo box and manually open the query it works fine and if I manually open the report after maunaully opening the query the report works fine. I am completely puzzled???? Thanks in advance for any assistance |
#15
|
|||
|
|||
Sorry need to make a correction
When I run the Query By its self I get a perameter promt [Forms]![Empl Reports]![Combo19] when I enter a specific name the query pulls the correct record "Klatuu" wrote: Okay, I still don't know exactly what the problem is, but here are a couple of things you can do. Post what you have in the filter property of the report, please. Be sure in your report you have the Filter On property set to true. Run the query stand alone, I mean without the form or the report open to see what result you get. We can make it work! "LT Larry" wrote: Klatuu I took the text off the end of the statement and the report is set up to filter not the query. It still is not working. When I run the query with the open form it is still blank. I also have a dropp down button in the name field of the query but when I select it the data filed is blank. Any suggestions: Thanks "Klatuu" wrote: LT, There are a couple of problems here. First, there is no [Text] property in VBA. That is VB. =[Forms]![Empl Reports]![Combo19] is the same as =[Forms]![Empl Reports]![Combo19].Value You also may want to take the filter criteria out of the query and put it in the report as the filter property. "LT Larry" wrote: Here are the steps I have already done: I have created an unbound form (Form 1) with an unbound Combo box (Combo19) containing Empl names.(control source is Employ tabl). On the form I have created a command Button to open a report (Report 1). I have created a query(Query 1) and in the last name field in have entered =[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using the expression builder I originally selected "value" in the last block but it did not work that is why there is the [Text] expression) I have create a report (Report 1) to open the Query. Problem: When I use the command button on the form to open the Report (After a name selection in the Combo box) the report is blank. I then created a command button to directly open the query from the form and it also comes up blank. But if I select a name from the combo box and manually open the query it works fine and if I manually open the report after maunaully opening the query the report works fine. I am completely puzzled???? Thanks in advance for any assistance |
#16
|
|||
|
|||
I entered the Expression
In Filter:"[Last Name] ='" & [Forms]![Empl Reports]![Combo19]&"'" And still get an oper Error I tried placing the Whe Clause and still the same message "Klatuu" wrote: I'm sorry L T, I only brought half of my brain in to work today. The other half is home asleep. It has to be like a where clause without the whe "[MyField] = '" & [Forms]![Empl Forms]![Combo19] & "'" Where [MyField] is the field you want to filter on. Again, my apologies. "LT Larry" wrote: Same message W/out the = sign "Klatuu" wrote: Try taking out the = sign. In the filter property for the report [Forms]![Empl Forms]![Combo19] "LT Larry" wrote: Ok I am on the same sheet now Did as instructed but recieved the following message Syntax Error (missing Operator) in query expression'(In Filter:=[Forms]![Empl Forms]![Combo19])' "Klatuu" wrote: I don't understand what you mean by "I deleted the field value an re-inserted it " Open your query in design mode and delete any criteria in it. You want all the filtering done from the report. Am I correct in assumint that combo19 is a control on your form you use to look up a value? [Forms]![Empl Reports]![Combo19] should be in the Filter property of your report. "LT Larry" wrote: Klatuu I deleted the field value an re-inserted it but I still get the Combo Box when I ref the critera control [forms]![Empl reports]![combo19] Field Properties: under the lookup tab Display Control: Combo Box Row Source Type: Field List Row Source: [forms]![Empl Reports]![Combo19] Also where do should I put In Filter: =[Forms]![Empl Reports]![Combo19] Thank you for your patience "Klatuu" wrote: True is the same as Yes, sorry I used the wrong term. It is the programmer in me. True = Yes = -1 False = No = 0 Take the drop down out of the query. There should be no criteria in the query at all. In Filter: =[Forms]![Empl Reports]![Combo19] Try this, let me know how it works. "LT Larry" wrote: Klatuu The Filter Properties are Filter: Blank Filter On: No Order By: Blank Order By On: yes When I run the Query by its self I get a blank row with a drop down button in the name field. I hope thats what you were looking for I changed the Filter On: to yes and the report retrieves all the records in the query. I am working with Access 2000 and do not have the option to set the value to true "Klatuu" wrote: Okay, I still don't know exactly what the problem is, but here are a couple of things you can do. Post what you have in the filter property of the report, please. Be sure in your report you have the Filter On property set to true. Run the query stand alone, I mean without the form or the report open to see what result you get. We can make it work! "LT Larry" wrote: Klatuu I took the text off the end of the statement and the report is set up to filter not the query. It still is not working. When I run the query with the open form it is still blank. I also have a dropp down button in the name field of the query but when I select it the data filed is blank. Any suggestions: Thanks "Klatuu" wrote: LT, There are a couple of problems here. First, there is no [Text] property in VBA. That is VB. =[Forms]![Empl Reports]![Combo19] is the same as =[Forms]![Empl Reports]![Combo19].Value You also may want to take the filter criteria out of the query and put it in the report as the filter property. "LT Larry" wrote: Here are the steps I have already done: I have created an unbound form (Form 1) with an unbound Combo box (Combo19) containing Empl names.(control source is Employ tabl). On the form I have created a command Button to open a report (Report 1). I have created a query(Query 1) and in the last name field in have entered =[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using the expression builder I originally selected "value" in the last block but it did not work that is why there is the [Text] expression) I have create a report (Report 1) to open the Query. Problem: When I use the command button on the form to open the Report (After a name selection in the Combo box) the report is blank. I then created a command button to directly open the query from the form and it also comes up blank. But if I select a name from the combo box and manually open the query it works fine and if I manually open the report after maunaully opening the query the report works fine. I am completely puzzled???? Thanks in advance for any assistance |
#17
|
|||
|
|||
I Entered the following statement
In Filter:"[Last Name] ='" & [Forms]![Patrol Reports]![Combo19]&"'" Still receiving a Missing Oper Error I try adding the where statement with the same results "Klatuu" wrote: I'm sorry L T, I only brought half of my brain in to work today. The other half is home asleep. It has to be like a where clause without the whe "[MyField] = '" & [Forms]![Empl Forms]![Combo19] & "'" Where [MyField] is the field you want to filter on. Again, my apologies. "LT Larry" wrote: Same message W/out the = sign "Klatuu" wrote: Try taking out the = sign. In the filter property for the report [Forms]![Empl Forms]![Combo19] "LT Larry" wrote: Ok I am on the same sheet now Did as instructed but recieved the following message Syntax Error (missing Operator) in query expression'(In Filter:=[Forms]![Empl Forms]![Combo19])' "Klatuu" wrote: I don't understand what you mean by "I deleted the field value an re-inserted it " Open your query in design mode and delete any criteria in it. You want all the filtering done from the report. Am I correct in assumint that combo19 is a control on your form you use to look up a value? [Forms]![Empl Reports]![Combo19] should be in the Filter property of your report. "LT Larry" wrote: Klatuu I deleted the field value an re-inserted it but I still get the Combo Box when I ref the critera control [forms]![Empl reports]![combo19] Field Properties: under the lookup tab Display Control: Combo Box Row Source Type: Field List Row Source: [forms]![Empl Reports]![Combo19] Also where do should I put In Filter: =[Forms]![Empl Reports]![Combo19] Thank you for your patience "Klatuu" wrote: True is the same as Yes, sorry I used the wrong term. It is the programmer in me. True = Yes = -1 False = No = 0 Take the drop down out of the query. There should be no criteria in the query at all. In Filter: =[Forms]![Empl Reports]![Combo19] Try this, let me know how it works. "LT Larry" wrote: Klatuu The Filter Properties are Filter: Blank Filter On: No Order By: Blank Order By On: yes When I run the Query by its self I get a blank row with a drop down button in the name field. I hope thats what you were looking for I changed the Filter On: to yes and the report retrieves all the records in the query. I am working with Access 2000 and do not have the option to set the value to true "Klatuu" wrote: Okay, I still don't know exactly what the problem is, but here are a couple of things you can do. Post what you have in the filter property of the report, please. Be sure in your report you have the Filter On property set to true. Run the query stand alone, I mean without the form or the report open to see what result you get. We can make it work! "LT Larry" wrote: Klatuu I took the text off the end of the statement and the report is set up to filter not the query. It still is not working. When I run the query with the open form it is still blank. I also have a dropp down button in the name field of the query but when I select it the data filed is blank. Any suggestions: Thanks "Klatuu" wrote: LT, There are a couple of problems here. First, there is no [Text] property in VBA. That is VB. =[Forms]![Empl Reports]![Combo19] is the same as =[Forms]![Empl Reports]![Combo19].Value You also may want to take the filter criteria out of the query and put it in the report as the filter property. "LT Larry" wrote: Here are the steps I have already done: I have created an unbound form (Form 1) with an unbound Combo box (Combo19) containing Empl names.(control source is Employ tabl). On the form I have created a command Button to open a report (Report 1). I have created a query(Query 1) and in the last name field in have entered =[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using the expression builder I originally selected "value" in the last block but it did not work that is why there is the [Text] expression) I have create a report (Report 1) to open the Query. Problem: When I use the command button on the form to open the Report (After a name selection in the Combo box) the report is blank. I then created a command button to directly open the query from the form and it also comes up blank. But if I select a name from the combo box and manually open the query it works fine and if I manually open the report after maunaully opening the query the report works fine. I am completely puzzled???? Thanks in advance for any assistance |
#18
|
|||
|
|||
LT,
I thought you took the lookup out of the query. That is absolutely necessary. That may be why you are getting the error. Also, I notice there is no space between the = sign and the single quote. Try changing that: In Filter:"[Last Name] ='" & [Forms]![Empl Reports]![Combo19]&"'" In Filter:"[Last Name] = '" & [Forms]![Empl Reports]![Combo19]&"'" Space goes here--------^ "LT Larry" wrote: Sorry need to make a correction When I run the Query By its self I get a perameter promt [Forms]![Empl Reports]![Combo19] when I enter a specific name the query pulls the correct record "Klatuu" wrote: Okay, I still don't know exactly what the problem is, but here are a couple of things you can do. Post what you have in the filter property of the report, please. Be sure in your report you have the Filter On property set to true. Run the query stand alone, I mean without the form or the report open to see what result you get. We can make it work! "LT Larry" wrote: Klatuu I took the text off the end of the statement and the report is set up to filter not the query. It still is not working. When I run the query with the open form it is still blank. I also have a dropp down button in the name field of the query but when I select it the data filed is blank. Any suggestions: Thanks "Klatuu" wrote: LT, There are a couple of problems here. First, there is no [Text] property in VBA. That is VB. =[Forms]![Empl Reports]![Combo19] is the same as =[Forms]![Empl Reports]![Combo19].Value You also may want to take the filter criteria out of the query and put it in the report as the filter property. "LT Larry" wrote: Here are the steps I have already done: I have created an unbound form (Form 1) with an unbound Combo box (Combo19) containing Empl names.(control source is Employ tabl). On the form I have created a command Button to open a report (Report 1). I have created a query(Query 1) and in the last name field in have entered =[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using the expression builder I originally selected "value" in the last block but it did not work that is why there is the [Text] expression) I have create a report (Report 1) to open the Query. Problem: When I use the command button on the form to open the Report (After a name selection in the Combo box) the report is blank. I then created a command button to directly open the query from the form and it also comes up blank. But if I select a name from the combo box and manually open the query it works fine and if I manually open the report after maunaully opening the query the report works fine. I am completely puzzled???? Thanks in advance for any assistance |
#19
|
|||
|
|||
Klatuu
I cut and paste the corrected string from the last post and I deleted the old query and built a new one with no Lookup and I am still receiving the Missing Op error "Klatuu" wrote: LT, I thought you took the lookup out of the query. That is absolutely necessary. That may be why you are getting the error. Also, I notice there is no space between the = sign and the single quote. Try changing that: In Filter:"[Last Name] ='" & [Forms]![Empl Reports]![Combo19]&"'" In Filter:"[Last Name] = '" & [Forms]![Empl Reports]![Combo19]&"'" Space goes here--------^ "LT Larry" wrote: Sorry need to make a correction When I run the Query By its self I get a perameter promt [Forms]![Empl Reports]![Combo19] when I enter a specific name the query pulls the correct record "Klatuu" wrote: Okay, I still don't know exactly what the problem is, but here are a couple of things you can do. Post what you have in the filter property of the report, please. Be sure in your report you have the Filter On property set to true. Run the query stand alone, I mean without the form or the report open to see what result you get. We can make it work! "LT Larry" wrote: Klatuu I took the text off the end of the statement and the report is set up to filter not the query. It still is not working. When I run the query with the open form it is still blank. I also have a dropp down button in the name field of the query but when I select it the data filed is blank. Any suggestions: Thanks "Klatuu" wrote: LT, There are a couple of problems here. First, there is no [Text] property in VBA. That is VB. =[Forms]![Empl Reports]![Combo19] is the same as =[Forms]![Empl Reports]![Combo19].Value You also may want to take the filter criteria out of the query and put it in the report as the filter property. "LT Larry" wrote: Here are the steps I have already done: I have created an unbound form (Form 1) with an unbound Combo box (Combo19) containing Empl names.(control source is Employ tabl). On the form I have created a command Button to open a report (Report 1). I have created a query(Query 1) and in the last name field in have entered =[Forms]![Empl Reports]![Combo19].[Text] for the Critera. (Note when using the expression builder I originally selected "value" in the last block but it did not work that is why there is the [Text] expression) I have create a report (Report 1) to open the Query. Problem: When I use the command button on the form to open the Report (After a name selection in the Combo box) the report is blank. I then created a command button to directly open the query from the form and it also comes up blank. But if I select a name from the combo box and manually open the query it works fine and if I manually open the report after maunaully opening the query the report works fine. I am completely puzzled???? Thanks in advance for any assistance |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mulitple Outlook problems | VanS | General Discussion | 4 | April 28th, 2005 08:45 PM |
Email send problems with DSL & Outlook | bmcdermo | General Discussion | 3 | April 1st, 2005 02:43 PM |
Disconnect Problems with Sending Email | jeff | General Discussion | 4 | January 18th, 2005 06:36 PM |
problems initiating mplay32.exe | electricrainbowfish | Powerpoint | 8 | July 8th, 2004 09:37 AM |
Problems with Style formatting | terrapinie | Formatting Long Documents | 2 | July 7th, 2004 06:18 PM |