Show Record data in Form from

[amycclark]

having trouble selecting a record to display on my form.

I have two tables [tblMain] and [tblPrjName]

[tblMain] contains an [id] and lots of information I want to display on my form.
[tblPrjName] contains the [id] and [ProjectName]

[id] is a unique value (i.e., no duplicates).

I want to add a combobox on my form where I can select the [ProjectName] from the list and then the form will display all the information from [tblMain] that I wish to show.

For some reason I can't figure this out how to select this record. It seems so basic.
:banghead:

From the row source in the properties for my combobox I can't seem to add anything in there that works.
Thoughts???
Thanks in advanced!
~Amy in NH

 

[RainLover]

A quick answer.

Depending on your version, you can insert a combo box using the Tools menu.

This should offer you the choice that you need.

Hope this helps. I am off soon.

 

[amycclark]

Thanks for the reply.
I have Access2010 and I should have been more specific... I have a combobox added but I can't get it to show the values of interest.

 

[RainLover]

Rebuild the Combo Box using the wizard.

Delete the current one.

I don't have 2010 so I am not sure what it contains.

 

[bitzgam]

Hello sir, on your combo box go to Data properties then click the Row Source and show the table tblPrjName and select the ID and the ProjectName field then on column bound set the property to 1 then on Format go to column count 2 and column width set it to 0 hope it helps

 

[RainLover]

Hello sir, on your combo box go to Data properties then click the Row Source and show the table tblPrjName and select the ID and the ProjectName field then on column bound set the property to 1 then on Format go to column count 2 and column width set it to 0 hope it helps

This is another way of doing things. However one change is that the Column Width should be something like 0,2

The zero hides the first column so you only see the column of 2.

 

[amycclark]

I figured it out.... my form was still pointing to table rather than a query that combined the tables. doh!

 

[RainLover]

I guess you won't forget that one too easily.

Cheers