Trying to learn!(Easy question)

[Saladsnake]

Hello everyone,

I'd like to take this opportunity to introduce myself. I'm a application developer that was recently hired to code various VBA automation software. I have a bit of coding under my belt and am looking to expand my horizons to VBA. I understand a lot of the VBA code as well as SQL all I really need to to bridge the gap to become a great Access developer!

Anyway, my issue is that I have a bunch of unbound text boxes that i need to populate from data fro a table. I also have a search box that with search by id(Primary key). I was trying to find a way to populate ever 20 or so text boxes with their corresponding data from the table.

I'm sure if I understand it i can replicate. So if someone could explain to be a unbound text box search that populates one or two text boxs i can read and extract that idea and put it into my code. really, the simpler that better.

Thanks for the help,

Salad

 

[jdraw]

Just curious why you are using unbound text boxes?
Can you give us a sample and how it would look using Search?

You might find this sample of use.

 

[Saladsnake]

Just curious why you are using unbound text boxes?
Can you give us a sample and how it would look using Search?

my boss recommended to me i should learn with unbound and would like to learn without the wizards helping me.

Ok say there was a group id like 384293

id like to put that number in a text box press enter, and since the number is a primary key it will target the record and populate, lets sat group name and group location in 2 separate text boxes.

Group name and group location are both in the same table as group id.

Does this help at all? let me know if you need anymore information.