By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,490 Members | 1,489 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,490 IT Pros & Developers. It's quick & easy.

Linking Parameter values of a query using form

P: 2
Hello

I m using MS Acces 2007, I need to create a form through which a user can enter all the parameter values in the form and these values will automatically picked by a query:

Here is the query which i want to link with a form
Expand|Select|Wrap|Line Numbers
  1. INSERT INTO [DSF Daily Activity Query mode] ( [Code:], [Month:], [Date:], [Cont Made], [Appt Made], [Appt Atten], [No of PFRs], Cases, Premium, [Rept Mgr Code:], [Rept Type:] )
  2.  
  3. SELECT [DSF Daily Activity 1].[Code:], [DSF Daily Activity 1].[Month:], [DSF Daily Activity 1].[Date:], [DSF Daily Activity 1].[Cont Made], [DSF Daily Activity 1].[Appt Made], [DSF Daily Activity 1].[Appt Atten], [DSF Daily Activity 1].[No of PFRs], [DSF Daily Activity 1].Cases, [DSF Daily Activity 1].Premium, [DSF Daily Activity 1].[Rept Mgr Code:], [DSF Daily Activity 1].[Rept Type:]
  4.  
  5. FROM [DSF Daily Activity 1]
  6.  
  7. WHERE ((([DSF Daily Activity 1].[Date:]) Between [From Date ] And [To Date])) OR ((([DSF Daily Activity 1].[Code:])=[Enter Code]));
I want "Form Date", "To Date" and "Enter Code" parameters to be linked with a form where a user can enter the values.

My form name is "Data Entry"

Please help me to resolve this problem.
Sep 23 '08 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,476
Referring to Items on a Sub-Form gives some clues, but in this case you simply want :
Expand|Select|Wrap|Line Numbers
  1. Forms![Data Entry]![From Name]
  2. Forms![Data Entry]![To Name]
  3. Forms![Data Entry]![Enter Code]
You may need to adjust the Control names to those you've actually defined.
Sep 23 '08 #2

P: 2
Thank You so much its really very helpful for me.
Sep 23 '08 #3

NeoPa
Expert Mod 15k+
P: 31,476
My pleasure :)

Welcome to Bytes!
Sep 23 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.