How to create a title combo box when i had many title is the same?

[Jeremy Sng]

I got a problem of create a combo box in the form. I got multiple title in my table. but it will overwrite some of the title which is the same

How can i overcome this problem?

[ranman256]

I dont understand the problem. You want to pick a title from a combo box then have it appear on a report?

[Jeremy Sng]

Nope.

Example:

in the combo box.

title:

1st. I am a boy
2nd. I am a boy

Both are different story but when i click the 2nd story it pop out the 1st story.

How i can overcome this problem?

[ranman256]

The query that pulls the story must look at the combo....
select * from table where [story]=forms!formMain!cboBox

[John_G]

You are going to have to include in the combo box some other data which uniquely identifies which story you want. That might be a story ID, an author name, etc., some data which when combined with the Story Name, will identify only one record.

What happens in your form after you select a story name?

[jacquienta]

when setting up the combo box add title and say date or year too. that way when it shows up in the combo it will appear as :

I am a boy 2013
I am a boy 2016

Helping u decipher between the two.

Hope this helps