Automatic Population of Field

[Gypsie Jones]

Hi,

I am putting together a simple database to do with monitoring maintenace of buildings. I was the building number to automatcially populate when the building name is select.

I have got the the point where I have building name and number in the building name combo box but i'm stuck with the after update code builer part.

I currently have:

Me.Building_NameControl = Me.Building_Number.Column(2)

But doesn't seem to work.

Can anyone help please.....I don't really understand syntax!

Many Thanks,

 

[pbaldy]

The Column property is zero based, so the second column would be 1.

 

[Gypsie Jones]

Thanks,

I've put this:

Me.Building_NameControl = Me.Building_Number.Column(1)

but still doesn't want to work.

:banghead:

 

[pbaldy]

Oh, it wants to work.

What is the column count property of the combo? It needs to be 2.

 

[Gypsie Jones]

Column count is at 2!

 

[pbaldy]

And that code is in the after update event of the combo? Can you post the db here?

 

[Gypsie Jones]

I think the code is in the right place. I'll upload the db in the morning. I'm away from my computer now.

I really appreciate your help. I'm on a steep learning curve!

 

[pbaldy]

Happy to help!

 

[Gypsie Jones]

I've attached my database.

Hope you can help.

 

[pbaldy]

Sorry, I'm dense and should have seen this. You have them reversed. Try

Me.Building_Number = Me.Building_Name.Column(1)

 

[Gypsie Jones]

Woo hoo...that is awesome....it works.

Thanks very much

 

[pbaldy]

Happy to help!

My daughter lived in England for several years and loved taking the train up to Scotland. I never made it during visits to her. Someday I'll make it up there!

 

[Gypsie Jones]

It's lovely if you come when it's not raining!