Hi friends,

I am desperate now....eeeeehhhhhh!!!!!!!!.

I have a combo box and it has duplicate records. I wish make this combo 
box to display a record at a time. Once I have completed my transaction 
for the first record only then the second record appears.

How can I do that?

Please help - SOS......

Thanks,
Maha

How are you assigning data to the combo box?
If you are using a query for your combo box then you could remove the 
duplicates in your query.

Derrick

>>> mahap@p... 10/24/02 07:38AM >>>
Hi friends,

I am desperate now....eeeeehhhhhh!!!!!!!!.

I have a combo box and it has duplicate records. I wish make this combo
box to display a record at a time. Once I have completed my transaction
for the first record only then the second record appears.

How can I do that?

Please help - SOS......

Thanks,
Maha

I am assigning data to the combo box from a table and not from a query. If 
possible I wish to maintain it like that. Otherwise, I can only make it 
with a query.

Thanks friend,
Maha

Hi Maha,

A typical fix for duplicate records in a combo box is to assign a
SELECT query as the combo boxes record source, but to include the
DISTINCT keyword in the SELECT statement, as in:

SELECT DISTINCT fld FROM tbl

I can't tell from the description of your problem, however, if thats
quite what your looking for. Hope ot helps.

Best,

Bob






>From: "Maha Arupputhan Pappan" <mahap@p...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] Combo Box - Urgent Advise
>Date: Thu, 24 Oct 2002 07:38:14
>
>Hi friends,
>
>I am desperate now....eeeeehhhhhh!!!!!!!!.
>
>I have a combo box and it has duplicate records. I wish make this combo
>box to display a record at a time. Once I have completed my transaction
>for the first record only then the second record appears.
>
>How can I do that?
>
>Please help - SOS......
>
>Thanks,
>Maha


_________________________________________________________________
Surf the Web without missing calls! Get MSN Broadband. 
http://resourcecenter.msn.com/access/plans/freeactivation.asp

Hi Bob and Derrick,

Thanks for your assistance.

Can I have both your emails, so that I can send you guys that small 
portion of the DB and you two can workout something.

Thanks,
Maha

Hi Maha,

I'm at bobbedell15@m... I'd be happy to help if I can.

>From: "Maha Arupputhan Pappan" <mahap@p...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] Re: Combo Box - Urgent Advise
>Date: Fri, 25 Oct 2002 02:37:22
>
>Hi Bob and Derrick,
>
>Thanks for your assistance.
>
>Can I have both your emails, so that I can send you guys that small
>portion of the DB and you two can workout something.
>
>Thanks,
>Maha


_________________________________________________________________
Choose an Internet access plan right for you -- try MSN! 
http://resourcecenter.msn.com/access/plans/default.asp