Subform query displaying names instead of Primary Key #?

[dkmidi]

Hi everyone,

I have 2 main tables: Orders and Users

there is a relationship between [Orders].UserID and [Users].UserID.

I have a form with a subform. The subform's data source is from a static query. When I choose my criteria from different controls (mix of combo/text boxes) and click my button, the criteria is sent to the static query and then the results spit out to the subform.

The problem is that I can't seem get the subform to display the User names instead of just the UserID.

Can anyone help?

Thanks very much!

Derek

 

[lastout]

I'm not sure I fully understand your problem, but the first thing that comes to mind is the number of bound columns in controls on the subform and their column widths. It sounds like you have both the ID and the name bound to a single control. If so, check to see if the column width property is set to 0";1". If it is, it will show the name, not the ID number. If you set the column widths to 1";1", you should see both values. Let me know if this helps or not. lastout (the game's not over till it's over)