abc123
07-11-2005, 05:08 PM
Hello,
I am trying to do a very simple thing in Access. I have 2 tables one is tblQuestions and the other is tblProjectQuestions.
In an MS Access 2000 form that actually uses these forms, I need to be able to first query from tblProjectQuestions to see if for a particular project, the questions have been answered. (I am passing the ProjectID as a parameter to the form). If the result of this query is null, then I need to read all the Questions from tblQuestions and display on the form.
On form close, I need to be able to either write records to tblProjectQUestions or update records in tblProjectQuestions depending on whether the questions exist or not.
Can anybody please point me to some code samples that helps me do the above?
Your help is greatly appreciated.
I am trying to do a very simple thing in Access. I have 2 tables one is tblQuestions and the other is tblProjectQuestions.
In an MS Access 2000 form that actually uses these forms, I need to be able to first query from tblProjectQuestions to see if for a particular project, the questions have been answered. (I am passing the ProjectID as a parameter to the form). If the result of this query is null, then I need to read all the Questions from tblQuestions and display on the form.
On form close, I need to be able to either write records to tblProjectQUestions or update records in tblProjectQuestions depending on whether the questions exist or not.
Can anybody please point me to some code samples that helps me do the above?
Your help is greatly appreciated.