update field not working

[aoswald]

I have a form with a combo box based on a table. When I enter a code in the combo box, I want the system to update other unbound text boxes with the other information in the table. I have it working in one form but not the other and I can't figure out what the difference is. The combo box is based on "Code" the unbound boxes have =code.colomn(0) The (0) changes depending on what info I want in the box It works really sweet in one form but not this one and I can't figure out the difference

Any suggestions would be appreciated

 

[pbaldy]

If that's a copy/paste, then column is spelled wrong.

 

[aoswald]

that's a typo

It's spelled correctly in the form

 

[pbaldy]

Is Code the name of the combo or the data field (since you say it's based on code)? You want the name of the combo (which should be different than the name of the field).

 

[aoswald]

I changed the name of the combo box

I changed the name of the combo box to payrollcode. now the forumla is =payrollcode.column(0). Still doesn't work

 

[pbaldy]

Hmm; what is the row source of the combo and the column count property? Can you post a sample? That looks like it should work.

 

[aoswald]

row source

row source is Offices Query

colunm count is 9

how would I post a sample?

 

[aoswald]

Got it!!!!!

had a typo in the formula - been staring at that thing for 2 days and couldn't see it

thanks for the help

 

[pbaldy]

You're welcome...even though I didn't do anything.