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 |
#1
|
|||
|
|||
Filtering to pull up certain information
I have a lookup box that pulls up different contract numbers (Contractnum).
With those different contract numbers, I have a lookup box that pulls up the different invoices with that number (Workordernum). My problem is I want to only see the invoices for that certain contract number. Right now (Workordernum) pulls up all the invoice numbers for the (contractnum) I select. |
#2
|
|||
|
|||
Filtering to pull up certain information
J,
I think you mean your WorkOrderNum brings up ALL existing Invoices, rather than just those Invoices associated with the selected ContractNum. So, if I understand... The query behind the RowSource of WorkOrderNum (combo box) must contain the ContractNum field, with a criteria of... (assuming ContractNum is on the main form) =Form!frmYourMainFormName!ContractNum You'll need to code a Requery for the WorkOrderNum on the AfterUpdate event of ContractNum. Now... WorkOrderNum should only show Invoices associated with the selected ContractNum. I have a 93 and 2003 sample file on my website below called Synched Combos. It will show how the above is implemented. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "jtidwell" wrote in message ... I have a lookup box that pulls up different contract numbers (Contractnum). With those different contract numbers, I have a lookup box that pulls up the different invoices with that number (Workordernum). My problem is I want to only see the invoices for that certain contract number. Right now (Workordernum) pulls up all the invoice numbers for the (contractnum) I select. |
#3
|
|||
|
|||
Filtering to pull up certain information
When you select (contractnum) on my form, it brings up all the information
associated with that "contractnum". I have it set up when you select the "contractnum" a new invoice generates for that specific "contractnum". For example if I select the "contractnum" A9000101F then a new invoice would generate F1006. The invoices generate Sequential. Now, I have a Invoice Lookup box that looks up all the invoices. Now what I want to do is only look up the invoices for lets say "contractnum" A9000101G, then what ever invoices would come up in the lookup box(G1002, G1003, ect). I have it where all the invoices pull up in the look-up box. I want to only see the invoices by the "contractnum" I select. "Al Campagna" wrote in message ... J, I think you mean your WorkOrderNum brings up ALL existing Invoices, rather than just those Invoices associated with the selected ContractNum. So, if I understand... The query behind the RowSource of WorkOrderNum (combo box) must contain the ContractNum field, with a criteria of... (assuming ContractNum is on the main form) =Form!frmYourMainFormName!ContractNum You'll need to code a Requery for the WorkOrderNum on the AfterUpdate event of ContractNum. Now... WorkOrderNum should only show Invoices associated with the selected ContractNum. I have a 93 and 2003 sample file on my website below called Synched Combos. It will show how the above is implemented. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "jtidwell" wrote in message ... I have a lookup box that pulls up different contract numbers (Contractnum). With those different contract numbers, I have a lookup box that pulls up the different invoices with that number (Workordernum). My problem is I want to only see the invoices for that certain contract number. Right now (Workordernum) pulls up all the invoice numbers for the (contractnum) I select. |
#4
|
|||
|
|||
Filtering to pull up certain information
What is the Parent-Child relationship between the two? You should have some
link between the two. Use that link as the filter criteria for the lookup box. Use a refresh on change event to "refresh" the lookup box filter. "jtidwell" wrote: When you select (contractnum) on my form, it brings up all the information associated with that "contractnum". I have it set up when you select the "contractnum" a new invoice generates for that specific "contractnum". For example if I select the "contractnum" A9000101F then a new invoice would generate F1006. The invoices generate Sequential. Now, I have a Invoice Lookup box that looks up all the invoices. Now what I want to do is only look up the invoices for lets say "contractnum" A9000101G, then what ever invoices would come up in the lookup box(G1002, G1003, ect). I have it where all the invoices pull up in the look-up box. I want to only see the invoices by the "contractnum" I select. "Al Campagna" wrote in message ... J, I think you mean your WorkOrderNum brings up ALL existing Invoices, rather than just those Invoices associated with the selected ContractNum. So, if I understand... The query behind the RowSource of WorkOrderNum (combo box) must contain the ContractNum field, with a criteria of... (assuming ContractNum is on the main form) =Form!frmYourMainFormName!ContractNum You'll need to code a Requery for the WorkOrderNum on the AfterUpdate event of ContractNum. Now... WorkOrderNum should only show Invoices associated with the selected ContractNum. I have a 93 and 2003 sample file on my website below called Synched Combos. It will show how the above is implemented. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "jtidwell" wrote in message ... I have a lookup box that pulls up different contract numbers (Contractnum). With those different contract numbers, I have a lookup box that pulls up the different invoices with that number (Workordernum). My problem is I want to only see the invoices for that certain contract number. Right now (Workordernum) pulls up all the invoice numbers for the (contractnum) I select. |
#5
|
|||
|
|||
Filtering to pull up certain information
I do not understand.
"Chris" wrote in message ... What is the Parent-Child relationship between the two? You should have some link between the two. Use that link as the filter criteria for the lookup box. Use a refresh on change event to "refresh" the lookup box filter. "jtidwell" wrote: When you select (contractnum) on my form, it brings up all the information associated with that "contractnum". I have it set up when you select the "contractnum" a new invoice generates for that specific "contractnum". For example if I select the "contractnum" A9000101F then a new invoice would generate F1006. The invoices generate Sequential. Now, I have a Invoice Lookup box that looks up all the invoices. Now what I want to do is only look up the invoices for lets say "contractnum" A9000101G, then what ever invoices would come up in the lookup box(G1002, G1003, ect). I have it where all the invoices pull up in the look-up box. I want to only see the invoices by the "contractnum" I select. "Al Campagna" wrote in message ... J, I think you mean your WorkOrderNum brings up ALL existing Invoices, rather than just those Invoices associated with the selected ContractNum. So, if I understand... The query behind the RowSource of WorkOrderNum (combo box) must contain the ContractNum field, with a criteria of... (assuming ContractNum is on the main form) =Form!frmYourMainFormName!ContractNum You'll need to code a Requery for the WorkOrderNum on the AfterUpdate event of ContractNum. Now... WorkOrderNum should only show Invoices associated with the selected ContractNum. I have a 93 and 2003 sample file on my website below called Synched Combos. It will show how the above is implemented. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "jtidwell" wrote in message ... I have a lookup box that pulls up different contract numbers (Contractnum). With those different contract numbers, I have a lookup box that pulls up the different invoices with that number (Workordernum). My problem is I want to only see the invoices for that certain contract number. Right now (Workordernum) pulls up all the invoice numbers for the (contractnum) I select. |
#6
|
|||
|
|||
Filtering to pull up certain information
Hi,
I think us volunteers are having trouble understanding how your form is set up. Below is some of the info you sent: When you select (contractnum) on my form, it brings up all the information associated with that "contractnum". I have it set up when you select the "contractnum" a new invoice generates for that specific "contractnum". For example if I select the "contractnum" A9000101F then a new invoice would generate F1006. The invoices generate Sequential. I imagine that you have a form set to single form. Make a selection from combo contractnum and the form uses a filter or find first to show the details for that contractnum. Is the above correct? When the new invoice generates does the new invoice form open? how can selecting a contractnum make the form show the details for that contractnum and also generate a new invoice? please help me understand how your form works. Below is some of the info you sent: Now, I have a Invoice Lookup box that looks up all the invoices. Now what I want to do is only look up the invoices for lets say "contractnum" A9000101G, then what ever invoices would come up in the lookup box(G1002, G1003, ect). I have it where all the invoices pull up in the look-up box. I want to only see the invoices by the "contractnum" I select. Where is the Invoice lookup box? what form is it on? is contractnum a combo on the same form? Are we looking at a form with one or two subforms? Jeanette Cunningham "jtidwell" wrote in message ... I do not understand. "Chris" wrote in message ... What is the Parent-Child relationship between the two? You should have some link between the two. Use that link as the filter criteria for the lookup box. Use a refresh on change event to "refresh" the lookup box filter. "jtidwell" wrote: When you select (contractnum) on my form, it brings up all the information associated with that "contractnum". I have it set up when you select the "contractnum" a new invoice generates for that specific "contractnum". For example if I select the "contractnum" A9000101F then a new invoice would generate F1006. The invoices generate Sequential. Now, I have a Invoice Lookup box that looks up all the invoices. Now what I want to do is only look up the invoices for lets say "contractnum" A9000101G, then what ever invoices would come up in the lookup box(G1002, G1003, ect). I have it where all the invoices pull up in the look-up box. I want to only see the invoices by the "contractnum" I select. "Al Campagna" wrote in message ... J, I think you mean your WorkOrderNum brings up ALL existing Invoices, rather than just those Invoices associated with the selected ContractNum. So, if I understand... The query behind the RowSource of WorkOrderNum (combo box) must contain the ContractNum field, with a criteria of... (assuming ContractNum is on the main form) =Form!frmYourMainFormName!ContractNum You'll need to code a Requery for the WorkOrderNum on the AfterUpdate event of ContractNum. Now... WorkOrderNum should only show Invoices associated with the selected ContractNum. I have a 93 and 2003 sample file on my website below called Synched Combos. It will show how the above is implemented. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "jtidwell" wrote in message ... I have a lookup box that pulls up different contract numbers (Contractnum). With those different contract numbers, I have a lookup box that pulls up the different invoices with that number (Workordernum). My problem is I want to only see the invoices for that certain contract number. Right now (Workordernum) pulls up all the invoice numbers for the (contractnum) I select. |
#7
|
|||
|
|||
Filtering to pull up certain information
Can you post a picture of your Relationship. That would help.
"jtidwell" wrote: I do not understand. "Chris" wrote in message ... What is the Parent-Child relationship between the two? You should have some link between the two. Use that link as the filter criteria for the lookup box. Use a refresh on change event to "refresh" the lookup box filter. "jtidwell" wrote: When you select (contractnum) on my form, it brings up all the information associated with that "contractnum". I have it set up when you select the "contractnum" a new invoice generates for that specific "contractnum". For example if I select the "contractnum" A9000101F then a new invoice would generate F1006. The invoices generate Sequential. Now, I have a Invoice Lookup box that looks up all the invoices. Now what I want to do is only look up the invoices for lets say "contractnum" A9000101G, then what ever invoices would come up in the lookup box(G1002, G1003, ect). I have it where all the invoices pull up in the look-up box. I want to only see the invoices by the "contractnum" I select. "Al Campagna" wrote in message ... J, I think you mean your WorkOrderNum brings up ALL existing Invoices, rather than just those Invoices associated with the selected ContractNum. So, if I understand... The query behind the RowSource of WorkOrderNum (combo box) must contain the ContractNum field, with a criteria of... (assuming ContractNum is on the main form) =Form!frmYourMainFormName!ContractNum You'll need to code a Requery for the WorkOrderNum on the AfterUpdate event of ContractNum. Now... WorkOrderNum should only show Invoices associated with the selected ContractNum. I have a 93 and 2003 sample file on my website below called Synched Combos. It will show how the above is implemented. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "jtidwell" wrote in message ... I have a lookup box that pulls up different contract numbers (Contractnum). With those different contract numbers, I have a lookup box that pulls up the different invoices with that number (Workordernum). My problem is I want to only see the invoices for that certain contract number. Right now (Workordernum) pulls up all the invoice numbers for the (contractnum) I select. |
Thread Tools | |
Display Modes | |
|
|