Funny in MS Access 2003 with a dropdown on a datasheet

Hi Gurus
I have a funny with a dropdown an a subform that I have created.  The data is not displaying and I can't for the life of me find out why.  I have rebuilt the database, Uninstalles and re-installed office and Ofiice service pack 3 redojne the form and am just not winning.  I have attached snapshots of the problem with my settings and Recordsources
Tx
Expenses.jpg
Category-Properties.jpg
Category-ControlSource.jpg
caandalAsked:
Who is Participating?
 
caandalAuthor Commented:
Hi Guys

No offence taken just - You know when you can't see the wood for the trees... I'm sure that you have both been there...frustrations at not being able to solve such a simple problem easily.  I have solved it by re-creating the Category table from scratch and naming it Expense Categories
0
 
MMierzwaCommented:
I am afraid that provided screenshot are not sufficient to solve this problem. Anyway have you tried to set first column width greater than 0 to see if there is something to display?
0
 
therealmongooseCommented:
The control source need to be linked to the field in the forms underlying table, not the catid from the combo controls sql... can you post the forms row source sql...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
mbizupCommented:
As a sanity check, do you have  blank "Catdescriptions"?
0
 
caandalAuthor Commented:
MMierzwa: Been there done that - id shows fine.  What else would you like me to post?

therealmongoose:I've been designing databases in acces since version 2 (more years than I care to remember) The control source of the field is from the underlying table and not anything else - what else would you possibly want to set as the controi source? I normally create a field in the child table with an index of the same name as the parent table.

mbizup: First thing that I checked - No Blanks
.
0
 
MMierzwaCommented:
We only try to help and sometimes even expert forget about simple and obvious things, so you must forgive us such questions. ;)
And the thing that  could us help is a chance to face the problem ourselves. So if it is possible you could attach database or part of it showing the problem.
0
 
therealmongooseCommented:
I would agree with MMierzwa; (please don't take offense over suggestions posted - sometimes it's the obvious that can be the problem...) Perhaps you could post a copy of the database or a portion thereof so we can have a closer look?
 
Kind regards,

therealmongoose
0
 
therealmongooseCommented:
Absolutely! - Glad you've fixed it... thanks for updating the question....
0
 
caandalAuthor Commented:
Guys thanx for your suggestions - I do appreciate the helpfullness of experts
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.