Pick an item from a list...

[ctB]

Okay, I have no idea if such a thing is possible, but this is
what I'd like to do.

I'm trying to make a database for a collection of Swiss Army Knives.
I'd like to create some kind of report or form or something that would
let me select a name of the knife from a list and it would then show
all the details of the item. Can something like this be done in Access?

Chris

 

[Duane Hookom]

Allen Browne has a sample of how to use a value in a control on a form to
filter a report at http://www.allenbrowne.com/casu-15.html.

 

[Ken Snell \(MVP\)]

And here's another example:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

 

[ctB]

And here's another example:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

Those are some good examples of what I'm trying to do, but
I'm having a hard time "copying" what's happening there into
my database. I think I'm copying most things right, but when
I click the command button, it asks me for a value instead of
taking it from my combo box. And idea what I'm not doing right?

Chris

 

[Larry Linson]

Those are some good examples of what I'm trying to do, but
I'm having a hard time "copying" what's happening there into
my database. I think I'm copying most things right, but when
I click the command button, it asks me for a value instead of
taking it from my combo box. And idea what I'm not doing right?

Have you modified the VBA code or macros to refer to your Forms and
Controls, instead of the ones in the sample?

Larry Linson
Microsoft Access MVP