TechSpot - PC Technology News and Analysis

Hello there,

I've one issue with MS Access forms. So, let me explain a bit this problem to you guys and hope you lads can help me one way or another.

Ok, so I've created a MS Access form wheres about 15 different object fields that are connected to one table. Next thing is, that I try to make one of those fields a some kind of search field, so when I type to that field some number like "2", it suppose to fill automatically all other fields as well. By the way, that "2" is unique number and every single data record have different number combination, but that isn't a primary key though.

Should I use queries/macros/visual basic code or what?

Any further questions etc. you want to know, please feel free to ask.

Cheers, IP