Achi, Ovi, The SQL WHERE clauses with the "cboCustomer" and "cboProduct" work because the required key is in the first position of the prior (superior) Combo Box SQL select.
The ROW SOURCE for the Customer Combo Box is; SELECT tblCusts.CustID, tblCusts.CustNumPaw, tblCusts.CustName FROM tblCusts ORDER BY tblCusts.CustNumPaw; The ROW SOURCE for the Product Combo Box is; SELECT Min(tblProducts.ProductID) AS MinOfProductID, tblProducts.ProductName, tblProducts.ProductDesc, tblProducts.CustID FROM tblProducts WHERE (((tblProducts.CustID)=[cboCustomer])) GROUP BY tblProducts.ProductName, tblProducts.ProductDesc, tblProducts.CustID ORDER BY tblProducts.ProductName; The ROW SOURCE for the Container Combo Box is; SELECT Min(tblContainers.ContainerID) AS MinOfContainerID, tblContainers.ContainerName FROM tblContainers WHERE (((tblContainers.ProductID)=[cboProduct])) GROUP BY tblContainers.ContainerName ORDER BY tblContainers.ContainerName; The ROW SOURCE for the Lot Combo Box is; SELECT Min(tblLots.LotID) AS MinOfLotID, tblLots.LotName, tblLots.LotDescription FROM tblLots WHERE (((tblLots.ProductID)=[cboProduct])) GROUP BY tblLots.LotName, tblLots.LotDescription ORDER BY tblLots.LotName, tblLots.LotDescription; In the VBA there is a lot of complexity that I am not showing, whose function is to link to add-functions when an item is not selected from the Combo box. Hope this helps Dick --- In [email protected], "Achi Rachimuddin" <[EMAIL PROTECTED]> wrote: > > Hi Dick, > > > > It could be better you post the code. > > > > My problems actually like this > > > > I have one field name cboObv and the other field name SafObv data type Memo. > > > > When I select a data from the cboObv then to the field safObv. First data > entry has done. I would select the second data by doing the same step in > which Select cboobv and safobv. > > > > What I want is when I entry the second data by selecting the cboobv, the > first data will directly updated to the table. But when we would go back to > the first data by selecting the combobox, the data still exist. > > > > Thank you in advance. > > > > Rgds, > > > Achi > > > > _____ > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of Dick Root > Sent: Monday, August 06, 2007 12:31 AM > To: [email protected] > Subject: [ms_access] Re: [AccessDevelopers] Combobox Entry Data > > > > Achi, > Are you trying to code cascading combo boxes - - the selected items in > the first box constrains the list in the second box which constrains > the list in the third box, etc.? > I solved that problem a few years ago (in VBA of course). If that's > what you need, please let me know and I will post the code. > Dick > > --- In [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com, > "Achi Rachimuddin" > <achi.rachimuddin@> wrote: > > > > Any one can help me? > > > > > > > > _____ > > > > From: AccessDevelopers@ <mailto:AccessDevelopers%40yahoogroups.com> > yahoogroups.com > > [mailto:AccessDevelopers@ <mailto:AccessDevelopers%40yahoogroups.com> > yahoogroups.com] On Behalf Of Achi Rachimuddin > > Sent: Thursday, August 02, 2007 7:24 AM > > To: AccessDevelopers@ <mailto:AccessDevelopers%40yahoogroups.com> > yahoogroups.com; belajar-access@ <mailto:belajar-access%40yahoogroups.com> > yahoogroups.com; > > [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com > > Subject: [AccessDevelopers] Combobox Entry Data > > Importance: High > > > > > > > > Dear all, > > > > > > > > I have a case like this. > > > > > > > > I have a combobox and another field to entry the data. > > > > For example, > > > > > > > > > > > > Private Sub cboObv_AfterUpdate() > > > > If cboObv = True Then > > > > DoCmd.GoToControl "SafObv" > > > > > > > > End If > > > > > > > > End Sub > > > > > > > > I want when I select the next new record the previous data selected > should > > be updated into the table. > > > > > > > > Can anyone help me with this? > > > > > > > > Thanks in advance. > > > > > > > > Rgds, > > > > > > > > Achi > > > > > > > > > > CONFIDENTIALITY CAUTION: > > This email is confidential. If you are not the addressee tell the sender > > immediately > > and destroy this email without using, sending or storing it. > > Emails are not secure and may suffer errors, viruses, delay, > interception > > and amendment. > > PT Darma Henwa does not accept liability for damage caused by this > email and > > may monitor email traffic. > > > > > > > > > > CONFIDENTIALITY CAUTION: > > This email is confidential. If you are not the addressee tell the sender > > immediately > > and destroy this email without using, sending or storing it. > > Emails are not secure and may suffer errors, viruses, delay, > interception > > and amendment. > > PT Darma Henwa does not accept liability for damage caused by this > email and > > may monitor email traffic. > > > > > > > > CONFIDENTIALITY CAUTION: > > This email is confidential. If you are not the addressee tell the > sender immediately > > and destroy this email without using, sending or storing it. > > Emails are not secure and may suffer errors, viruses, delay, > interception and amendment. > > PT Darma Henwa does not accept liability for damage caused by this > email and may monitor email traffic. > > > > > > [Non-text portions of this message have been removed] > > > > > > > > CONFIDENTIALITY CAUTION: > This email is confidential. If you are not the addressee tell the sender immediately > and destroy this email without using, sending or storing it. > Emails are not secure and may suffer errors, viruses, delay, interception and amendment. > PT Darma Henwa does not accept liability for damage caused by this email and may monitor email traffic. > > > [Non-text portions of this message have been removed] >
