Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

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
0
caandal
Asked:
caandal
  • 3
  • 3
  • 2
  • +1
1 Solution
 
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
 
mbizupCommented:
As a sanity check, do you have  blank "Catdescriptions"?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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
 
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
 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now