Concantantion Problems???

[Toby1kenobe]

HI

i'm pretty sure thats spelt wrong!

I'm doing a DB which is school based working with form groups. I've kept the year and regestration part seperate, ie form names go 7A 7B 7O 8T 9U etc. so the table holds the number (ie 7) and letter (ie C) seperate. I'm recording daily incidents and am combining the Year and Reg back together for each record. So i have this kind of thing in my combo box

SELECT year, reg, (year & reg) AS form FROM tblforms;

this displays the form names ok but when i try to select a form name it will only let me select 7A not 7B or 7C.

The bound column is 3 in my combo.

Any ideas how i can make it select another choice?

Any help is always greatly appreciated

Toby

ps can anyone spell concantanation (or say it!)

 

[mph1]

The following is the correct spelling:


concatenation

Also, try the following and look up under Search

http://www.mvps.org/access/

An investment in knowledge always pays the best dividends.

by Benjamin Franklin

 

[Toby1kenobe]

Hi

I was only joking about the spelling. I've sorted the problem now. I said in my posting that the bound col was 3, it wasn't but when i set it to 3- problem solved

Toby