asked on

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

peter57r

You are using CustomerID as the link field from your main form to (at least one) subform.

yddadsjd95

ASKER

Thank you Peter57r, Shouldn't that CustomerID already have a value in it?

yddadsjd95

ASKER

Should I be using another link field?

Helen Feddema

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).

Helen Feddema

Removing tblVehicles from the main form's record source eliminated the parameter message about CustomerID.

yddadsjd95

ASKER

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?

SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

yddadsjd95

ASKER

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

yddadsjd95

ASKER

Oops, I neglected to compile the file I loaded. Here is the corrected version.

thanks,

David
IndependentAuto---EE---9-12-11--.zip

ASKER CERTIFIED SOLUTION

mbizup

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

yddadsjd95

ASKER

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

mbizup

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.