KenHigg

Hi
can u pls added me on ur msn. my id is pmmohamedali@gmail.com
need some help for access.

Thank you.

I'll have to keep a eye on that girl -

A survey published in a newspaper today showed that the most searched for recipe was cupcake, should you be worried.

Hi Ken,
In a post regarding a survey, you said:

"c. The main question going in for me would be do you want to hard code the questions or be able to 'configure' them from input forms, etc.?"

I'd like to know what exactly you meant by that because I think this is what I'm looking for.

I have my db normalized correctly (apparantly) with a linking table tblAnswers in between my main tblCalls and tblQuestions.

tblAnswers has the following structure:
tblAnswers
CallID
QuestionID
AnswerID

My question is, I want to have a static form with the answers hard coded onto the form, lets say frmMain.

Now, through asking questions, I have come up with some code that will pull the questions (about 20) from tblQuestions, and write them with the current CallID (CallID is the main driving Primary Key for the DB) off of tblCalls, onto tblAnswers

My problem is that now that the questions are listed in tblAnswers, how can I link the AnswerID field to the combobox pull downs on frmMain.

ie. Let's assume I am on Call 10, question 1.

I have a combobox pull down with the question posed as a label:

Did the Representative greet the caller [PULL DOWN BOX]

Inside the pull down box, three answers are populated from another table, tblAnswerValues, YES/NO/NA

I need that unbound combobox form control to update the already existing record in tblAnswers as follows:

CallID/10
QuestionID/1
AnswerID/[whatever is picked in the pull down box]

But I can't seem to get an answer from anyone! I think what you were asking is what I am looking for...

i have post it
it says the code works

the code cdbl works. Expr1: CDbl(Right([DBA_INC_LOAN_BANK]![BRANCH_NUMBER],3)) this it the way i put it and it works now this result is in three digit number and i have to compare it to a field that whe you compare it could gave me a name for that value

Can you post it to the forum - ?

hi i need your help again

waaaa, your all expert. Perhaps I'm not belong here.....

hi ken,

I have confuse using access 2007. please help, I can't find tool to startup my form on it.

Thanks for that Ken, works a treat, the beer is on me if you are ever near Hannover Germany

Ken, I didn't know WHO nominated me; I knew HOW I became an MVP. My comment was mostly that it was unexpected. I had not visited for at least a month due to some really extensive business travel for my primary work system (not an MS product).

Ok... I'll post it to the thread...

KenHiggs - thank you for your help. I would still like to understan how the Dlookup() works.