Display search results on form

Hey /r/Access — I’m new to Access but an Excel/VBA pro so if someone can just point me in the right direction, I’d really appreciate it!

I have a data table that has an “Item Number” field. I’m trying to build a form that allows a user to type in an Item Number and all the records with that item number (will be 1 to 10 rows total) will be displayed on the UserForm, sorted by a “date” field. User doesn’t need to interact with these records in any way, just needs to the see the text in a simple table.

What’s the general approach here? What control should I use and what’s the method to populate it?

I’ve been googling/searching around but having trouble finding an example.


submitted by /u/pancak3d
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on