Trying to populate data into form.......I'm an access beginner

[dmorand]

I've got a form which is created from a table. The table contains values from other linked tables. which have primary keys which are stored in the main table.

Here an example of the problem I'm having:

I have a field called "Application Request" that I want to display on the form. It is a combo box which can contain various entries:

"Masterfile"
"Printed Form"
"Report".....etc etc etc

When I put the control source "Application Request" on the form, I'm getting the key, not the actual value. 1 is in the combo box, not "Masterfile".

Do I need to modify the query for the form to include all of the values from the linked tables that I want? I would have thought that if I was retrieving the key values I could retrieve any of the data from the linked tables.

Is there something special I can put in the control source to pull the data by having only the key?

 

[zyxwvu44]

in the properties, set the first column width to 0, the second to 1", or however wide you want it. so, it will look like this:

0";1"

 

[dmorand]

But I'm only seeing the Key field added. What does column width have to do with that?

 

[dmorand]

The control source I have is the key field from the table. I can't add the value item from the linked table. It's not in the drop-down list.

 

[zyxwvu44]

try changing the bound column to 1 or 2

 

[ColinEssex]

Forms should have a query as their record source - not the table. This allows for more flexibility in joining several tables in the query if necessary.

Col

 

[zyxwvu44]

for the record source try:
SELECT table.[ID], table.[name] FROM table ORDER BY [name];