Recent content by absolutered03

bump for more ideas

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...

Anyone else have ideas?

You're correct, the table that drives the DB currently is tblCalls. Those candidates for dropdowns- they are comobox lookups populating from other tables. It is an interesting proposal that you've brought forth...and I'm still thinking my way through it to see if I can figure something else...

bump! Any ideas anyone? I'm still stuck on this...

Thanks! I think that is what I was looking for!

Hey Chris, Attached is a screenshot of the form the way I wish it could be done, in the 'unbound form' way. The top portion with simple call details could still be bound, but the bottome portion, with the questions I gather would have to be unbound. Anyhow, I think with subforms, it just will...

I guess to be more specific: 1. I use the simpler after update method to populate the questions in tblAnswers for the current Call_ID 2. Using my main form, create combobox pulldown controls that relate to the newly populated records in table answers (ie. lets say I create control comboWelcome...

Sorry for the confusion. The functionality of the subform works great...it does exactly what it is supposed to do. However, if it is possible, it would be better if I didn't need to use a subform in datasheet format. Or perhaps if there were a way I could format it differently...? My manager...

Chris, Thank you very much! This method populates the questions in the table correctly, and has gotten me one step closer to the functionality I need for the database. Now that the questions are populating on tblAnswers correclty, is there a way to create a pulldown combobox, unbound, that when...

Hi Guys, I have a situation with which I would love some assistance, if possible. TblCalls CallID CallDate RepName TblAnswers AnswerID CallID QuestionID AnswerValueID I have two forms: frmCalls txtCallDate txtRepname memoNotes subfrmAnswers I wrote a query which populates a set of 40...

ugh. Im a Noob! I wrote an append query that writes all the questions into the tblAnswers. Simple enough! haha. Now, how can I get it to add the current CallID on the main form, run whenever a new record is created, and only if there are no records for that CallID in tblAnwers...so as not to...

I found some code on another thread that had a similar issue; it is an sql statement. I've modified it for my application, but where would I store it so it would do it for every next/new record?: INSERT INTO [subfrmAnswers] (QuestionID, Call_ID, AnswerValueID) " & _ "SELECT...

Chris, Thanks for the response! I basically have it setup in that fashion currently. My only issue is that there is ~40 questions per call, so I would like the questions to auto-populate on the subform for each new call record, so that they dont have to pull down each question first. Not as...

Thanks for posting back. Your help is very much appreciated. I have gotten as far as creating the comboboxes with the correct responses in the pull down. The problem is that I can't relate the answers back to a new record in tblAnswers. See, because tblAnswers holds the three foreign keys...