Coding HELP!!!

[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

 

[BruceM via AccessMonster.com]

I have read this message several times, and I still do not understand what
you are trying to do. That you have not yet received a reply suggests others
may be similarly puzzled.

At first I thought you were trying to open a new record based on the current
(or selected record), but then the survey was added to the mix. "Just add a
whole new survey" glosses over how the survey fits into the picture. Your c)
has the user answering several new questions, but where did they come from?
For that matter, where are the questions, and how are you managing the survey?
Are there more tables than you have described?

More information, please.

 

[Marshall Barton]

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

In addition to BruceM's comments, the structure of those
three tables has a couple of conflicts. The many to many
junction table takes care of linking contacts and companies
so you can not have the contactID in the companies table,
Similarly, you can not have the compantID in the contacts
table.

 

[Dennis]

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.

 

[tom_willpa]

high quality Soccer jerseys NBA Jersey tracksuit and jackets, GHD
hairstraightener supplier from www.willpa.com

Are you a Retail businessman who bother by the purchase price? China
Cheapest TOP wholesale website can help you

we are specialize in replica sport goods manufacturing in china, we can
offer you all kinds of soccer jersey, NBA jersey,shoes and so on. they are
the best brand replica goods whih are look the same as the original goods.
excellent quality and steady supply for them. we have been marketed in Europe
and American for 3 year. all the goods we offer are AAA quality. our soccer
jersey are Thailand style. If any goods you buy from my company have problem,
we will refund or resend them again. Most of ourProducts have no minimum
order requirements,soyou can shop retail goods at wholesale prices. if you
can buy more than 300usd. We offer free shipping. The more you buy the more
discount for you.

National soccer jerseys: http://www.willpa.com
Club soccer jerseys: http://www.willpa.com
NBA Jerseys: http://www.willpa.com
T-shirt and shirt: http://www.willpa.com
Tracksuit: http://www.willpa.com
Hoody & Jackets: http://www.willpa.com
UGG boots: http://www.willpa.com
Hair style: http://www.willpa.com
shopping Index: http://www.willpa.com

EMS shipping. 7days arrive, paypal accept

want more information pls contact us or check our website: www.willpa.com