Solved Deleted records in Table showing as blank spaces in Combobox and Listbox

[rayape]

I have a database with a table labeled [tbl_Participant]. A combobox is populated from this table. There are 10 deleted records in the table which are not consecutive. The combobox (and listbox) adds blank spaces in the beginning. I don't know what is going on. How can I get rid of these blank spaces? Included is a screenshot of what the combobox does.

Appreciate your help.
Thank you.

 

[theDBguy]

Hi. What is the Row Source of your Listbox?

 

[rayape]

It's the same table, [tbl_Participant].

 

[theDBguy]

It's the same table, [tbl_Participant].

Are you able to post a demo version of your db showing the issue only?

 

[rayape]

@theDBguy, sorry I don't have a demo version. I am working with thousands of records already keyed in. Sorry.

This was not a problem earlier. It started two days ago after adding a few hundred records to already existing several hundreds records.

Any advise, direction, help will be greatly appreciated. Thanks.

 

[theDBguy]

@theDBguy, sorry I don't have a demo version. I am working with thousands of records already keyed in. Sorry.

This was not a problem earlier. It started two days ago after adding a few hundred records to already existing several hundreds records.

Any advise, direction, help will be greatly appreciated. Thanks.

It's hard to say what could cause it and how to fix it without seeing something to give us a clue. Are you sure there are no blank records in the table? How exactly are you deleting the records?

 

[rayape]

There are 10 records deleted from the table. For ex: there is rows 1, 2, 3, 4, 5, 6, 9, 10.....Rows 7 and 8 are deleted. The gentleman who deleted can't explain properly how he deleted. I am so lost.

When I look at the table, I do see rows 7 and 8 missing.

 

[theDBguy]

There are 10 records deleted from the table. For ex: there is rows 1, 2, 3, 4, 5, 6, 9, 10.....Rows 7 and 8 are deleted. The gentleman who deleted can't explain properly how he deleted. I am so lost.

When I look at the table, I do see rows 7 and 8 missing.

Since we can't see what you're looking at, it's hard to say what's wrong with it. Sorry.

 

[rayape]

@theDBguy: Found the problem. The gentleman showed me he did not delete the entire row, but only the values in those fields. This was creating blank rows in the combobox and listbox. Because there are literally thousands of records, it wasn't easy to catch them.

Thanks for your time and advise. You were right in pointing me in the right direction in your 3rd post. Appreciate the help.

Resolved.

 

[theDBguy]

@theDBguy: Found the problem. The gentleman showed me he did not delete the entire row, but only the values in those fields. This was creating blank rows in the combobox and listbox. Because there are literally thousands of records, it wasn't easy to catch them.

Thanks for your time and advise. You were right in pointing me in the right direction in your 3rd post. Appreciate the help.

Resolved.

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.