seeking solution to synchronize two combo boxes on a subform

#1 (**permalink**) 28-Jul-2006, 08:12 AM

I have successfully synchronize two combo boxes on a subform named as
suborderdetail and the master form is frmorderentry. The two combo boxes is
cbocategory and cboproduct. Unfortunately, when I try to enter the
orderdetail and to make selection in list of the category and products, all
the rest of the records changed and became exactly the same as the latest
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10417-seeking-solution-synchronize-two-combo-boxes.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
entry I just made. For instance, when I enter in the 10th order with cat-A,
prod-a, all my previous entries and the entries that I have not made, they
all shows cat-A, prod-a. Please kindly advice what should I do?I want every
single entry is kept as I selected from the list of those two combo boxes.

#2 (**permalink**) 28-Jul-2006, 08:12 AM

Sounds as though you don't have the combo boxes bound to a field in the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
underlying table/query.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"whitesnow" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
news:95332592-7984-4E37-AD1C-B857068A7824@microsoft.com...
>I have successfully synchronize two combo boxes on a subform named as
> suborderdetail and the master form is frmorderentry. The two combo boxes
> is
> cbocategory and cboproduct. Unfortunately, when I try to enter the
> orderdetail and to make selection in list of the category and products,
> all
> the rest of the records changed and became exactly the same as the latest
> entry I just made. For instance, when I enter in the 10th order with
> cat-A,
> prod-a, all my previous entries and the entries that I have not made, they
> all shows cat-A, prod-a. Please kindly advice what should I do?I want
> every
> single entry is kept as I selected from the list of those two combo boxes.
>

#3 (**permalink**) 28-Jul-2006, 08:13 AM

Thank you very much for your suggestion and I have now changed them to bound
boxes. But then I have other problems, when I try to make selection for the
new record from the list of category, the run time error dialogue pops up. In
fact I put below codes into the cbocategory afterupdated event:

private sub cboCategory_AfterUpdate()
me.cboproduct = Null
Me.cboproduct.requery
me.cboproduct = me.cboproduct.itemdate(0)
End sub

Could you please kind enought to point out what should I do and thank you
again for taking the time to address my inquiry as well as bearing with me
that I am a beginner of using Access.

"Douglas J. Steele" wrote:

> Sounds as though you don't have the combo boxes bound to a field in the
> underlying table/query.
>
> --
> Doug Steele, Microsoft Access MVP
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "whitesnow" wrote in message
> news:95332592-7984-4E37-AD1C-B857068A7824@microsoft.com...
> >I have successfully synchronize two combo boxes on a subform named as
> > suborderdetail and the master form is frmorderentry. The two combo boxes
> > is
> > cbocategory and cboproduct. Unfortunately, when I try to enter the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
> > orderdetail and to make selection in list of the category and products,
> > all
> > the rest of the records changed and became exactly the same as the latest
> > entry I just made. For instance, when I enter in the 10th order with
> > cat-A,
> > prod-a, all my previous entries and the entries that I have not made, they
> > all shows cat-A, prod-a. Please kindly advice what should I do?I want
> > every
> > single entry is kept as I selected from the list of those two combo boxes.
> >
>
>
>

#4 (**permalink**) 28-Jul-2006, 08:13 AM

Assuming that's copied and pasted, it should be itemdata, not itemdate.

If it isn't copied and pasted, what's the real code you're using?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"whitesnow" wrote in message
news:0408E237-6746-4AB6-8A27-8EEEB9670E44@microsoft.com...
> Thank you very much for your suggestion and I have now changed them to
bound
> boxes. But then I have other problems, when I try to make selection for
the
> new record from the list of category, the run time error dialogue pops up.
In
> fact I put below codes into the cbocategory afterupdated event:
>
> private sub cboCategory_AfterUpdate()
> me.cboproduct = Null
> Me.cboproduct.requery
> me.cboproduct = me.cboproduct.itemdate(0)
> End sub
>
> Could you please kind enought to point out what should I do and thank you
> again for taking the time to address my inquiry as well as bearing with me
> that I am a beginner of using Access.
>
> "Douglas J. Steele" wrote:
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
> > Sounds as though you don't have the combo boxes bound to a field in the
> > underlying table/query.
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no private e-mails, please)
> >
> >
> > "whitesnow" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
> > news:95332592-7984-4E37-AD1C-B857068A7824@microsoft.com...
> > >I have successfully synchronize two combo boxes on a subform named as
> > > suborderdetail and the master form is frmorderentry. The two combo
boxes
> > > is
> > > cbocategory and cboproduct. Unfortunately, when I try to enter the
> > > orderdetail and to make selection in list of the category and
products,
> > > all
> > > the rest of the records changed and became exactly the same as the
latest
> > > entry I just made. For instance, when I enter in the 10th order with
> > > cat-A,
> > > prod-a, all my previous entries and the entries that I have not made,
they
> > > all shows cat-A, prod-a. Please kindly advice what should I do?I want
> > > every
> > > single entry is kept as I selected from the list of those two combo
boxes.
> > >
> >
> >
> >

#5 (**permalink**) 28-Jul-2006, 08:13 AM

Sorry it was typo mistake, in fact it was correctly written as itemdata in
the cboCategory after update event procedure. Could you please kindly enough
to go ahead to point out what should I do next?

Many thanks

"Douglas J Steele" wrote:

> Assuming that's copied and pasted, it should be itemdata, not itemdate.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
>
> If it isn't copied and pasted, what's the real code you're using?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "whitesnow" wrote in message
> news:0408E237-6746-4AB6-8A27-8EEEB9670E44@microsoft.com...
> > Thank you very much for your suggestion and I have now changed them to
> bound
> > boxes. But then I have other problems, when I try to make selection for
> the
> > new record from the list of category, the run time error dialogue pops up.
> In
> > fact I put below codes into the cbocategory afterupdated event:
> >
> > private sub cboCategory_AfterUpdate()
> > me.cboproduct = Null
> > Me.cboproduct.requery
> > me.cboproduct = me.cboproduct.itemdate(0)
> > End sub
> >
> > Could you please kind enought to point out what should I do and thank you
> > again for taking the time to address my inquiry as well as bearing with me
> > that I am a beginner of using Access.
> >
> > "Douglas J. Steele" wrote:
> >
> > > Sounds as though you don't have the combo boxes bound to a field in the
> > > underlying table/query.
> > >
> > > --
> > > Doug Steele, Microsoft Access MVP
> > > http://I.Am/DougSteele
> > > (no private e-mails, please)
> > >
> > >
> > > "whitesnow" wrote in message
> > > news:95332592-7984-4E37-AD1C-B857068A7824@microsoft.com...
> > > >I have successfully synchronize two combo boxes on a subform named as
> > > > suborderdetail and the master form is frmorderentry. The two combo
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
> boxes
> > > > is
> > > > cbocategory and cboproduct. Unfortunately, when I try to enter the
> > > > orderdetail and to make selection in list of the category and
> products,
> > > > all
> > > > the rest of the records changed and became exactly the same as the
> latest
> > > > entry I just made. For instance, when I enter in the 10th order with
> > > > cat-A,
> > > > prod-a, all my previous entries and the entries that I have not made,
> they
> > > > all shows cat-A, prod-a. Please kindly advice what should I do?I want
> > > > every
> > > > single entry is kept as I selected from the list of those two combo
> boxes.
> > > >
> > >
> > >
> > >
>
>
>

#6 (**permalink**) 28-Jul-2006, 08:13 AM

What error are you getting?

Which column is the bound column in your combo box, and which column is the
visible one?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
(no private e-mails, please)

"whitesnow" wrote in message
news:BB0A9F92-5C11-464E-8250-D00CEAA12F44@microsoft.com...
> Sorry it was typo mistake, in fact it was correctly written as itemdata in
> the cboCategory after update event procedure. Could you please kindly
> enough
> to go ahead to point out what should I do next?
>
> Many thanks
>
> "Douglas J Steele" wrote:
>
>> Assuming that's copied and pasted, it should be itemdata, not itemdate.
>>
>> If it isn't copied and pasted, what's the real code you're using?
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "whitesnow" wrote in message
>> news:0408E237-6746-4AB6-8A27-8EEEB9670E44@microsoft.com...
>> > Thank you very much for your suggestion and I have now changed them to
>> bound
>> > boxes. But then I have other problems, when I try to make selection for
>> the
>> > new record from the list of category, the run time error dialogue pops
>> > up.
>> In
>> > fact I put below codes into the cbocategory afterupdated event:
>> >
>> > private sub cboCategory_AfterUpdate()
>> > me.cboproduct = Null
>> > Me.cboproduct.requery
>> > me.cboproduct = me.cboproduct.itemdate(0)
>> > End sub
>> >
>> > Could you please kind enought to point out what should I do and thank
>> > you
>> > again for taking the time to address my inquiry as well as bearing with
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
>> > me
>> > that I am a beginner of using Access.
>> >
>> > "Douglas J. Steele" wrote:
>> >
>> > > Sounds as though you don't have the combo boxes bound to a field in
>> > > the
>> > > underlying table/query.
>> > >
>> > > --
>> > > Doug Steele, Microsoft Access MVP
>> > > http://I.Am/DougSteele
>> > > (no private e-mails, please)
>> > >
>> > >
>> > > "whitesnow" wrote in message
>> > > news:95332592-7984-4E37-AD1C-B857068A7824@microsoft.com...
>> > > >I have successfully synchronize two combo boxes on a subform named
>> > > >as
>> > > > suborderdetail and the master form is frmorderentry. The two combo
>> boxes
>> > > > is
>> > > > cbocategory and cboproduct. Unfortunately, when I try to enter the
>> > > > orderdetail and to make selection in list of the category and
>> products,
>> > > > all
>> > > > the rest of the records changed and became exactly the same as the
>> latest
>> > > > entry I just made. For instance, when I enter in the 10th order
>> > > > with
>> > > > cat-A,
>> > > > prod-a, all my previous entries and the entries that I have not
>> > > > made,
>> they
>> > > > all shows cat-A, prod-a. Please kindly advice what should I do?I
>> > > > want
>> > > > every
>> > > > single entry is kept as I selected from the list of those two combo
>> boxes.
>> > > >
>> > >
>> > >
>> > >
>>
>>
>>

#7 (**permalink**) 28-Jul-2006, 08:14 AM

In the combo box of cboCategory, the bound column is 1 and the visible column
is the 2nd. In table of tblCategory, there are 2 fields, which are
categoryID and categoryName.

I tried deleting Me.cboProduct = Null and Me.cboProduct =
Me.cboProduct.itemdata(0), it looks like the cbocategory and the snycronized
combo boxes are working fine, but the product that I selected from the
corresponding category is not kept visible when I click to the next line. I
just could not figure out why.

I wish I could copy you the screen to better explain the problem.

Many thanks for your great patient.

"Douglas J. Steele" wrote:

> What error are you getting?
>
> Which column is the bound column in your combo box, and which column is the
> visible one?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "whitesnow" wrote in message
> news:BB0A9F92-5C11-464E-8250-D00CEAA12F44@microsoft.com...
> > Sorry it was typo mistake, in fact it was correctly written as itemdata in
> > the cboCategory after update event procedure. Could you please kindly
> > enough
> > to go ahead to point out what should I do next?
> >
> > Many thanks
> >
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
> > "Douglas J Steele" wrote:
> >
> >> Assuming that's copied and pasted, it should be itemdata, not itemdate.
> >>
> >> If it isn't copied and pasted, what's the real code you're using?
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no e-mails, please!)
> >>
> >>
> >> "whitesnow" wrote in message
> >> news:0408E237-6746-4AB6-8A27-8EEEB9670E44@microsoft.com...
> >> > Thank you very much for your suggestion and I have now changed them to
> >> bound
> >> > boxes. But then I have other problems, when I try to make selection for
> >> the
> >> > new record from the list of category, the run time error dialogue pops
> >> > up.
> >> In
> >> > fact I put below codes into the cbocategory afterupdated event:
> >> >
> >> > private sub cboCategory_AfterUpdate()
> >> > me.cboproduct = Null
> >> > Me.cboproduct.requery
> >> > me.cboproduct = me.cboproduct.itemdate(0)
> >> > End sub
> >> >
> >> > Could you please kind enought to point out what should I do and thank
> >> > you
> >> > again for taking the time to address my inquiry as well as bearing with
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
> >> > me
> >> > that I am a beginner of using Access.
> >> >
> >> > "Douglas J. Steele" wrote:
> >> >
> >> > > Sounds as though you don't have the combo boxes bound to a field in
> >> > > the
> >> > > underlying table/query.
> >> > >
> >> > > --
> >> > > Doug Steele, Microsoft Access MVP
> >> > > http://I.Am/DougSteele
> >> > > (no private e-mails, please)
> >> > >
> >> > >
> >> > > "whitesnow" wrote in message
> >> > > news:95332592-7984-4E37-AD1C-B857068A7824@microsoft.com...
> >> > > >I have successfully synchronize two combo boxes on a subform named
> >> > > >as
> >> > > > suborderdetail and the master form is frmorderentry. The two combo
> >> boxes
> >> > > > is
> >> > > > cbocategory and cboproduct. Unfortunately, when I try to enter the
> >> > > > orderdetail and to make selection in list of the category and
> >> products,
> >> > > > all
> >> > > > the rest of the records changed and became exactly the same as the
> >> latest
> >> > > > entry I just made. For instance, when I enter in the 10th order
> >> > > > with
> >> > > > cat-A,
> >> > > > prod-a, all my previous entries and the entries that I have not
> >> > > > made,
> >> they
> >> > > > all shows cat-A, prod-a. Please kindly advice what should I do?I
> >> > > > want
> >> > > > every
> >> > > > single entry is kept as I selected from the list of those two combo
> >> boxes.
> >> > > >
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>
>

#8 (**permalink**) 28-Jul-2006, 08:14 AM

Hold on. You're talking about a continuous form, aren't you.

See whether what Rob Mastrostefano has at
http://www.fmsinc.com/free/newtips/a...ccesstip16.asp is what you're
talking about.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"whitesnow" wrote in message
news:B2219E42-FDD5-47CD-8C19-7079DABE961B@microsoft.com...
> In the combo box of cboCategory, the bound column is 1 and the visible
> column
> is the 2nd. In table of tblCategory, there are 2 fields, which are
> categoryID and categoryName.
>
> I tried deleting Me.cboProduct = Null and Me.cboProduct =
> Me.cboProduct.itemdata(0), it looks like the cbocategory and the
> snycronized
> combo boxes are working fine, but the product that I selected from the
> corresponding category is not kept visible when I click to the next line.
> I
> just could not figure out why.
>
> I wish I could copy you the screen to better explain the problem.
>
> Many thanks for your great patient.
>
> "Douglas J. Steele" wrote:
>
>> What error are you getting?
>>
>> Which column is the bound column in your combo box, and which column is
>> the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
>> visible one?
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "whitesnow" wrote in message
>> news:BB0A9F92-5C11-464E-8250-D00CEAA12F44@microsoft.com...
>> > Sorry it was typo mistake, in fact it was correctly written as itemdata
>> > in
>> > the cboCategory after update event procedure. Could you please kindly
>> > enough
>> > to go ahead to point out what should I do next?
>> >
>> > Many thanks
>> >
>> > "Douglas J Steele" wrote:
>> >
>> >> Assuming that's copied and pasted, it should be itemdata, not
>> >> itemdate.
>> >>
>> >> If it isn't copied and pasted, what's the real code you're using?
>> >>
>> >> --
>> >> Doug Steele, Microsoft Access MVP
>> >> http://I.Am/DougSteele
>> >> (no e-mails, please!)
>> >>
>> >>
>> >> "whitesnow" wrote in message
>> >> news:0408E237-6746-4AB6-8A27-8EEEB9670E44@microsoft.com...
>> >> > Thank you very much for your suggestion and I have now changed them
>> >> > to
>> >> bound
>> >> > boxes. But then I have other problems, when I try to make selection
>> >> > for
>> >> the
>> >> > new record from the list of category, the run time error dialogue
>> >> > pops
>> >> > up.
>> >> In
>> >> > fact I put below codes into the cbocategory afterupdated event:
>> >> >
>> >> > private sub cboCategory_AfterUpdate()
>> >> > me.cboproduct = Null
>> >> > Me.cboproduct.requery
>> >> > me.cboproduct = me.cboproduct.itemdate(0)
>> >> > End sub
>> >> >
>> >> > Could you please kind enought to point out what should I do and
>> >> > thank
>> >> > you
>> >> > again for taking the time to address my inquiry as well as bearing
>> >> > with
>> >> > me
>> >> > that I am a beginner of using Access.
>> >> >
>> >> > "Douglas J. Steele" wrote:
>> >> >
>> >> > > Sounds as though you don't have the combo boxes bound to a field
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
>> >> > > in
>> >> > > the
>> >> > > underlying table/query.
>> >> > >
>> >> > > --
>> >> > > Doug Steele, Microsoft Access MVP
>> >> > > http://I.Am/DougSteele
>> >> > > (no private e-mails, please)
>> >> > >
>> >> > >
>> >> > > "whitesnow" wrote in message
>> >> > > news:95332592-7984-4E37-AD1C-B857068A7824@microsoft.com...
>> >> > > >I have successfully synchronize two combo boxes on a subform
>> >> > > >named
>> >> > > >as
>> >> > > > suborderdetail and the master form is frmorderentry. The two
>> >> > > > combo
>> >> boxes
>> >> > > > is
>> >> > > > cbocategory and cboproduct. Unfortunately, when I try to enter
>> >> > > > the
>> >> > > > orderdetail and to make selection in list of the category and
>> >> products,
>> >> > > > all
>> >> > > > the rest of the records changed and became exactly the same as
>> >> > > > the
>> >> latest
>> >> > > > entry I just made. For instance, when I enter in the 10th order
>> >> > > > with
>> >> > > > cat-A,
>> >> > > > prod-a, all my previous entries and the entries that I have not
>> >> > > > made,
>> >> they
>> >> > > > all shows cat-A, prod-a. Please kindly advice what should I do?I
>> >> > > > want
>> >> > > > every
>> >> > > > single entry is kept as I selected from the list of those two
>> >> > > > combo
>> >> boxes.
>> >> > > >
>> >> > >
>> >> > >
>> >> > >
>> >>
>> >>
>> >>
>>
>>
>>

#9 (**permalink**) 28-Jul-2006, 08:14 AM

Many thanks, Douglas. This solved the problem.

"Douglas J. Steele" wrote:

> Hold on. You're talking about a continuous form, aren't you.
>
> See whether what Rob Mastrostefano has at
> http://www.fmsinc.com/free/newtips/a...ccesstip16.asp is what you're
> talking about.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "whitesnow" wrote in message
> news:B2219E42-FDD5-47CD-8C19-7079DABE961B@microsoft.com...
> > In the combo box of cboCategory, the bound column is 1 and the visible
> > column
> > is the 2nd. In table of tblCategory, there are 2 fields, which are
> > categoryID and categoryName.
> >
> > I tried deleting Me.cboProduct = Null and Me.cboProduct =
> > Me.cboProduct.itemdata(0), it looks like the cbocategory and the
> > snycronized
> > combo boxes are working fine, but the product that I selected from the
> > corresponding category is not kept visible when I click to the next line.
> > I
> > just could not figure out why.
> >
> > I wish I could copy you the screen to better explain the problem.
> >
> > Many thanks for your great patient.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
> >
> > "Douglas J. Steele" wrote:
> >
> >> What error are you getting?
> >>
> >> Which column is the bound column in your combo box, and which column is
> >> the
> >> visible one?
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no private e-mails, please)
> >>
> >>
> >> "whitesnow" wrote in message
> >> news:BB0A9F92-5C11-464E-8250-D00CEAA12F44@microsoft.com...
> >> > Sorry it was typo mistake, in fact it was correctly written as itemdata
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10417
> >> > in
> >> > the cboCategory after update event procedure. Could you please kindly
> >> > enough
> >> > to go ahead to point out what should I do next?
> >> >
> >> > Many thanks
> >> >
> >> > "Douglas J Steele" wrote:
> >> >
> >> >> Assuming that's copied and pasted, it should be itemdata, not
> >> >> itemdate.
> >> >>
> >> >> If it isn't copied and pasted, what's the real code you're using?
> >> >>
> >> >> --
> >> >> Doug Steele, Microsoft Access MVP
> >> >> http://I.Am/DougSteele
> >> >> (no e-mails, please!)
> >> >>
> >> >>
> >> >> "whitesnow" wrote in message
> >> >> news:0408E237-6746-4AB6-8A27-8EEEB9670E44@microsoft.com...
> >> >> > Thank you very much for your suggestion and I have now changed them
> >> >> > to
> >> >> bound
> >> >> > boxes. But then I have other problems, when I try to make selection
> >> >> > for
> >> >> the
> >> >> > new record from the list of category, the run time error dialogue
> >> >> > pops
> >> >> > up.
> >> >> In
> >> >> > fact I put below codes into the cbocategory afterupdated event:
> >> >> >
> >> >> > private sub cboCategory_AfterUpdate()
> >> >> > me.cboproduct = Null
> >> >> > Me.cboproduct.requery
> >> >> > me.cboproduct = me.cboproduct.itemdate(0)
> >> >> > End sub
> >> >> >
> >> >> > Could you please kind enought to point out what should I do and
> >> >> > thank
> >> >> > you
> >> >> > again for taking the time to address my inquiry as well as bearing
> >> >> > with
> >> >> > me
> >> >> > that I am a beginner of using Access.
> >> >> >
> >> >> > "Douglas J. Steele" wrote:
> >> >> >
> >> >> > > Sounds as though you don't have the combo boxes bound to a field
> >> >> > > in
> >> >> > > the
> >> >> > > underlying table/query.
> >> >> > >
> >> >> > > --
> >> >> > > Doug Steele, Microsoft Access MVP
> >> >> > > http://I.Am/DougSteele
> >> >> > > (no private e-mails, please)
> >> >> > >
> >> >> > >
> >> >> > > "whitesnow" wrote in message
> >> >> > > news:95332592-7984-4E37-AD1C-B857068A7824@microsoft.com...
> >> >> > > >I have successfully synchronize two combo boxes on a subform
> >> >> > > >named
> >> >> > > >as
> >> >> > > > suborderdetail and the master form is frmorderentry. The two
> >> >> > > > combo
> >> >> boxes
> >> >> > > > is
> >> >> > > > cbocategory and cboproduct. Unfortunately, when I try to enter
> >> >> > > > the
> >> >> > > > orderdetail and to make selection in list of the category and
> >> >> products,
> >> >> > > > all
> >> >> > > > the rest of the records changed and became exactly the same as
> >> >> > > > the
> >> >> latest
> >> >> > > > entry I just made. For instance, when I enter in the 10th order
> >> >> > > > with
> >> >> > > > cat-A,
> >> >> > > > prod-a, all my previous entries and the entries that I have not
> >> >> > > > made,
> >> >> they
> >> >> > > > all shows cat-A, prod-a. Please kindly advice what should I do?I
> >> >> > > > want
> >> >> > > > every
> >> >> > > > single entry is kept as I selected from the list of those two
> >> >> > > > combo
> >> >> boxes.
> >> >> > > >
> >> >> > >
> >> >> > >
> >> >> > >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>