Form is asking for a parameter value

Great Day, I am trying to create an estimate for a customer that is having repair work done to his/her vehicle. When I click the customer's vehicle which the estimate is for, Access is requesting a parameter value for CustomerID. I know this sounds like a broken record from programmers of my skill level, but I've looked at every query and field name on the forms, but have been unable to discover why there is a CustomerID that does not have a value.

I have enclosed a copy of the db with the following instructions:

Click on frmCustomerContactData
highlight vehicle to be serviced
click "Repair Order" button

Thanks in advance for your assistance.

r/David
IndependentAuto---EE---9-12-11.zip
yddadsjd95Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mbizupConnect With a Mentor Commented:
In the code behind the command button used to open the Repair Order form, change the open form statement to:

                DoCmd.OpenForm "frmJob", , , WhereCondition:="CustomerID = " & Forms!frmCustomerContactData!txtCustomerID


(Drop the prefix on CustomerID)
0
 
peter57rCommented:
You are using CustomerID as the link field from your main form to (at least one) subform.
0
 
yddadsjd95Author Commented:
Thank you Peter57r, Shouldn't that CustomerID already have a value in it?
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
yddadsjd95Author Commented:
Should I be using another link field?
0
 
Helen FeddemaCommented:
I see two problems:  tblVehicles is in the record source of the main form; remove it.  It isn't needed there, just for the linked subform.  Then, in the code running from the Print Repair Order button, one field in the subform is referenced as VehicleMakeID, when it is actually MakeID.  Also, the form in question doesn't exist (I presume that is because this database is still in development).
0
 
Helen FeddemaCommented:
Removing tblVehicles from the main form's record source eliminated the parameter message about CustomerID.  
0
 
yddadsjd95Author Commented:
Thank you Helen, but I am still getting the same error, even after removing tblVehicles from the main form's record source. Shouldn't CustomerID already have a value in it?
0
 
peter57rConnect With a Mentor Commented:
You don't have a field called Customerid in your main form. You have changed it in your query to give it a' table_ ' prefix.
0
 
yddadsjd95Author Commented:
Thanks Peter57r, I removed the table prefix and it now is CustomerID but I am still getting the same error. Here is the SQL:

SELECT tblJobs.JobID, tblJobs.CustomerID, tblJobs.VehicleID, tblJobs.JobTypeID, tblJobs.RepairDateIn, tblJobs.RepairDateOut, tblJobs.WarrantyWorkPerformed, tblJobs.DateOfWarrantyWork, tblJobs.DescribeWarrantyWork, tblJobs.RepairMilageIn, tblJobs.RepairMileageOut, tblJobs.EmployeeID, tblJobs.PaymentMethod, tblJobs.Last5Digits, tblJobs.MiscellaneousCost
FROM tblJobs;

But what is strange is that when I run the query from design view, it runs with no problem.


r/David
0
 
yddadsjd95Author Commented:
Oops, I neglected to compile the file I loaded. Here is the corrected version.

thanks,

David
IndependentAuto---EE---9-12-11--.zip
0
 
yddadsjd95Author Commented:
Thank you mbizup, Peter57r told me of the prefix issue, but I looked in the wrong place for it.

Thanks to everyone the request for  parameter value has been eliminated, but I am still not receiving the expected results. with the 'WhereCondition' I was expecting the new estimate to fill with the customer's contact and vehicle information, which I will ask in about in another question.

Have a great day today and an even greater one tomorrow!

r/David
0
 
mbizupCommented:
David,

As an aside, are these real people's names, phone numbers, etc in your customers table?  If so, you may want to hit the Request Attention button and ask the Mods to help you get these uploads 'sanitized' to protect their privacy.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.