|
| 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
March 11th, 2009, 07:32 PM
posted to microsoft.public.access
|
|||
|
|||
Struggling
I have a drop down list of customers to reference on a order entry form. Each
customer has several different contracts associated with them, which are in another dropdown list. I would like it whne I choose a customer from the customer list that in the contract list it shows ONLY the contracts of the customer NOT all the contracts! Any suggestions from anyone? I would greatly appreiciate anything! 
|
|
#2
March 11th, 2009, 07:40 PM
posted to microsoft.public.access
|
|||
|
|||
|
Struggling
See if this helps: http://www.mvps.org/access/forms/frm0028.htm
John "gvaughn" schreef in bericht ... I have a drop down list of customers to reference on a order entry form. Each customer has several different contracts associated with them, which are in another dropdown list. I would like it whne I choose a customer from the customer list that in the contract list it shows ONLY the contracts of the customer NOT all the contracts! Any suggestions from anyone? I would greatly appreiciate anything!
|
|
#3
March 11th, 2009, 08:13 PM
posted to microsoft.public.access
|
|||
|
|||
|
Struggling
Thank you for the suggestion. It almost works now. The problem now is that
when you choose a customer, since each customer has multiple contracts, it pops up an enter paramter value dialog box. Anything you can think of that I am not would be benificial. THank you though for the help thus far. "John J." wrote: See if this helps: http://www.mvps.org/access/forms/frm0028.htm John "gvaughn" schreef in bericht ... I have a drop down list of customers to reference on a order entry form. Each customer has several different contracts associated with them, which are in another dropdown list. I would like it whne I choose a customer from the customer list that in the contract list it shows ONLY the contracts of the customer NOT all the contracts! Any suggestions from anyone? I would greatly appreiciate anything!
|
|
#4
March 11th, 2009, 08:19 PM
posted to microsoft.public.access
|
|||
|
|||
|
Struggling
The SELECT statement is as follows.
i am SELECTing ActiveContract FROM the Client table my WHERE statement is comparing the Client name to the Form.OrderEntry.Customer combolist. THe paratmer value is asking form the Form.OrderEntry.Customer value. "gvaughn" wrote: Thank you for the suggestion. It almost works now. The problem now is that when you choose a customer, since each customer has multiple contracts, it pops up an enter paramter value dialog box. Anything you can think of that I am not would be benificial. THank you though for the help thus far. "John J." wrote: See if this helps: http://www.mvps.org/access/forms/frm0028.htm John "gvaughn" schreef in bericht ... I have a drop down list of customers to reference on a order entry form. Each customer has several different contracts associated with them, which are in another dropdown list. I would like it whne I choose a customer from the customer list that in the contract list it shows ONLY the contracts of the customer NOT all the contracts! Any suggestions from anyone? I would greatly appreiciate anything!
|
|
#5
March 11th, 2009, 09:30 PM
posted to microsoft.public.access
|
|||
|
|||
|
Struggling
Did you try Forms in stead of Form?
Forms.OrderEntryForm.Customer John "gvaughn" schreef in bericht ... The SELECT statement is as follows. i am SELECTing ActiveContract FROM the Client table my WHERE statement is comparing the Client name to the Form.OrderEntry.Customer combolist. THe paratmer value is asking form the Form.OrderEntry.Customer value. "gvaughn" wrote: Thank you for the suggestion. It almost works now. The problem now is that when you choose a customer, since each customer has multiple contracts, it pops up an enter paramter value dialog box. Anything you can think of that I am not would be benificial. THank you though for the help thus far. "John J." wrote: See if this helps: http://www.mvps.org/access/forms/frm0028.htm John "gvaughn" schreef in bericht ... I have a drop down list of customers to reference on a order entry form. Each customer has several different contracts associated with them, which are in another dropdown list. I would like it whne I choose a customer from the customer list that in the contract list it shows ONLY the contracts of the customer NOT all the contracts! Any suggestions from anyone? I would greatly appreiciate anything!
|
|
#6
March 11th, 2009, 10:10 PM
posted to microsoft.public.access
|
|||
|
|||
|
Struggling
yeah, thanks that got rid of the parameter value DB but now the combobox is
not populating at all. I don't want to bug you anymore, bbut thanks for all the help. I got at least this far today "John J." wrote: Did you try Forms in stead of Form? Forms.OrderEntryForm.Customer John "gvaughn" schreef in bericht ... The SELECT statement is as follows. i am SELECTing ActiveContract FROM the Client table my WHERE statement is comparing the Client name to the Form.OrderEntry.Customer combolist. THe paratmer value is asking form the Form.OrderEntry.Customer value. "gvaughn" wrote: Thank you for the suggestion. It almost works now. The problem now is that when you choose a customer, since each customer has multiple contracts, it pops up an enter paramter value dialog box. Anything you can think of that I am not would be benificial. THank you though for the help thus far. "John J." wrote: See if this helps: http://www.mvps.org/access/forms/frm0028.htm John "gvaughn" schreef in bericht ... I have a drop down list of customers to reference on a order entry form. Each customer has several different contracts associated with them, which are in another dropdown list. I would like it whne I choose a customer from the customer list that in the contract list it shows ONLY the contracts of the customer NOT all the contracts! Any suggestions from anyone? I would greatly appreiciate anything!
|
|
#7
March 11th, 2009, 10:59 PM
posted to microsoft.public.access
|
|||
|
|||
|
Struggling
"John J." schrieb im Newsbeitrag ... Did you try Forms in stead of Form? Forms.OrderEntryForm.Customer John "gvaughn" schreef in bericht ... The SELECT statement is as follows. i am SELECTing ActiveContract FROM the Client table my WHERE statement is comparing the Client name to the Form.OrderEntry.Customer combolist. THe paratmer value is asking form the Form.OrderEntry.Customer value. "gvaughn" wrote: Thank you for the suggestion. It almost works now. The problem now is that when you choose a customer, since each customer has multiple contracts, it pops up an enter paramter value dialog box. Anything you can think of that I am not would be benificial. THank you though for the help thus far. "John J." wrote: See if this helps: http://www.mvps.org/access/forms/frm0028.htm John "gvaughn" schreef in bericht ... I have a drop down list of customers to reference on a order entry form. Each customer has several different contracts associated with them, which are in another dropdown list. I would like it whne I choose a customer from the customer list that in the contract list it shows ONLY the contracts of the customer NOT all the contracts! Any suggestions from anyone? I would greatly appreiciate anything!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
