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.
Get the best Microsoft Access conultant
Get the best Microsoft Access programmer