Combo Box and auto fill to text box problems

[Stika]

Hi,



Im having some issues with my combo box, it pulls 1 field out of the database but not the other 4 that I want to be auto filled. The only field im saving in the new database is the customer name.

If someone can have a look and tell me what I stuffed up as im pulling my hair out over it. im using access 2010 btw

Cheers,

[pbaldy]

I can't look at the sample right now, but see if this helps:

http://www.baldyweb.com/Autofill.htm

[Stika]

Hi,

I've read over that 100 times and still to no luck , I think its in my code somewhere that I have stuffed up

[pbaldy]

I was on an iPad earlier, so couldn't look at the sample. The problem is the column count property of the combo. It should be 6, since that's how many fields are in the row source.

[Stika]

Yeah, Thanks

I just worked that one out as you replyed.

Thanks for your help

[pbaldy]

No problem, glad you got it sorted out.