Coding HELP!!!

  • Thread starter Thread starter cinvest
  • Start date Start date
C

cinvest

I have created a dbase that I admit may not be the most efficient use of VBA
but is nearly complete, EXCEPT:

1) when the user is in the dashboard ( a form to view records in 3 different
tables joined by query) they need the ability to accomplish 3 specific tasks:

a) scroll to a record, select it which opens up a 2-tabbed form (already
created) that autopopulates various info from the previous dashboard (e.g.
name, contact number, etc) by contactID on one tab but allows the user to
answer several new questions creating a new surveyID (eg. a new record in
the tbl 3).
b) just add a whole new survey (this is easy I think my code for this is
fine…as I’m using the DoCmd. Open Form)
c) scroll to a record, select it which opens up the 2-tabbed form
(referenced in a) that autopopulates various info from the previous dashboard
(e.g. name, contact number, company name etc) by contactID & company ID on
one tab but allows the user to answer several new questions creating a new
surveyID (eg. a new record in the tbl 3).
Abridged Version of Table Structure

tbl1 has
CompanyID as PK
Company Name
Contact ID as FK

tbl 2 has
Contact Name
Contact ID as PK
CompanyID as FK

tbl 3 has
SurveyID as PK
ContactID as FK
CompanyID as FK


Dominique
 
I have to agree with Bruce and Marsh. You are not being at all clear on
exactly what you're trying to do, AND exactly what problems you're having and
where they arise.
 
Back
Top