Combo Box malfunction

[accessuser67]

Currently, I have a form that has two combo box and the second combo box relies on the first to filter the second combo box. It was working fine but now the second combo box does not allow me to select from the drop down list. It resorts to the first record each time and when I try to change the selection it goes right back to the first record in the drop down list.

Please help me. Your assistance with this will be greatly appreciated.

Best Regards,
Ekmoorhead

 

[John Big Booty]

Are you able to post a copy of your DB?

Simply do a compact an repair on it, place it in a zip file, and upload the Zip file.

 

[accessuser67]

My database is attached:

Looking forward to your suggestions.

Regards.

 

[John Big Booty]

I'll take a look at it when I have access to a latter version of Access.

 

[John Big Booty]

Firstly which form is that I need to be looking at?

Secondly you may want to read up on the subject of Data Normalisation and even work through a tutorial on the subject.

Thirdly you may want to consider implementing a naming protocol, along the lines of TBL_TableName, FRM_FromName, QRY_QueryName etc. this will make much clearer which object you are referring to in your code.

 

[accessuser67]

GroceryF is the form I'm referring to.

Thanks.

Regards.