Showing Related Data in a Form

[pbaldy]

I have that code in the after update event of the combo:



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

[GregWatling]

I have tired so many things that I have got it all messed up now & it's getting late here in the UK. I have been working on this for about 8 hours today, I will go back to an earlier version tomorrow & go through this topic, hopefully getting things right and get a successful result.

Thanks for your help so far guys, I will let you knwo how I get on.

Why cant things be easy?

[GregWatling]

Just a thought, would this be easier if I made fields in the table and pulled the data in from the second table & stored them rather than trying to just show them in a virtual kind of way?

[pbaldy]

I wouldn't. It would typically violate normalization rules to store duplicate data, and this situation doesn't appear to qualify for an exception.

[GregWatling]

EUREKA!

Thanks Guys, after a nights sleep & coming back at this from the start, I have managed to do it & it is very simple.

I have added two text boxes next to my selection drop down with the Control Source as

=[SectorL2a].[Column](2)
=[SectorL2a].[Column](3)

they now fill in correctly and all is good.

thanks for all of your help

[pbaldy]

Glad you got it sorted out.