combo box-how to use all fields

[desimoreno]

Hi, I'm sending this out again, in hopes someone will see it. I've attached a very stripped down version of my database. I created a combo box with 3 or 4 fields. normally, you open your combo box, find the record of choice, and you've already chosen which field will be linked to another field. what I'm wanting to do, is when I open my combo box, I wall all 3 fields shown in the combo box to populate certain fields in my form. . please help. .

thank you in advanced

PS, I've read way in which one can create search tables, or something like this, I've never done that, but I would be willing to learn if it make things work.

[pbaldy]

Is this what you're looking for?

BaldyWeb - Autofill

[desimoreno]

thanks. . I've tried that, but I don't think my database is set up in a way it would work

[pbaldy]

Really? It works fine for me.

[desimoreno]

I guess I'm not filling in my fields correctly?.. . can you give me a screen shot of what you changed?

[pbaldy]

Private Sub Combo79_AfterUpdate()
  Me.Project_Name = Me.Combo79.Column(1)
  Me.Project_Number_Final = Me.Combo79.Column(0)
End Sub

[desimoreno]

ok.. I did it.. . it worked.. .thank you a million over. . but I don't have a clue what I did. . I'll have to learn about what I just did. . I was trying to put this code as the control source.. . I think what I'm mostly confused about is the "Me" portion. . but as I'm looking at it now. .if I had more columns (or fields), then I would be just adding more "Me".s, and the number at the far right is the column number. . .ok. . I'm getting it. .other then the ME thing. .
thanks again for your patience. . I really appreciate it

[pbaldy]

"Me" is a shortcut to refer to the object the code is in. In this case, the form named main. So these are the same thing, when the code is behind that form:

Me.Project_Name
Forms!Main.Project_Name

Another advantage to it is that as soon as you type "Me." you'll get a dropdown of available properties, members, methods, etc. Makes it harder to mistype anything.

[desimoreno]

I think I see. . .time to school myself some more. .
have a great day
desi

[pbaldy]

You too desi!