Listbox issue - foreign key showing up, need value instead

[Destin Richter]

Hi, I've a form called frmNotes that has fields: one field is a combo box
where you can select the note category (drawing from tblNoteCat) and another
memo field where one can type in details. The source for this form is
tblNote. I have since added a listbox so users can select the existing data
by seeing a given note category, and then the form will refresh and bring up
the data that corresponds (this is sound much more complicated than it is).
Anyway, my listbox shows the primary key of the tblNoteCat field instead of
the descriptions. I'd be happy to send my table and form to anyone who think
they might know how to adjust my control source settings.

Thank you!

Destin Richter
(e-mail address removed)

 

[Destin Richter]

Never mind, folks. Went to the underlying data source, turned into query
style, added the original table holding the values, and all works well now.

How do I delete a post?

Thanks!

 

[Don Starnes]

I have the same problem, but I don't understand how you solved it! What do
you mean "turned into query style"? I added the table holding the values to
my query in design view, but while the query showed the lookup values, they
didn't show in the listbox. I assumed that a listbox won't show a lookup
value the same way that the datasheet view of a queyr will. Is this correct?

 

[Destin Richter]

Don, I'm not great with the VBA/SQL language, so when I go into the row
source of my control, i click the 3 dots to get into a query-style view.
From there, I just added the table I needed. If you want, send the database
components over (table and form) and I'll resolve it, then send it back.
Might go faster this way.

Destin Richter
(e-mail address removed)

 

[Destin Richter]

Don, did you get my reply? There was an error on my post, for some reason.
Send the underlying table and form to me and I'll resolve it (if I can) and
send it back. Might take less time that way.

Destin
(e-mail address removed)