Hello,
Sorry about the wrong read just thought id need to explain what i needed.
Ive been creating a Database system for my mums partner's business. He is a thrill ride inspector, therefore he inspects rides you get in fairs. He has Customers Information and the customers rides. Everything is working great but there is one niggle that he would like to avoid.
I have created a form to Book Inspections, all works ok. I have fields that include Customer Id, Customer 1st name, Second name and then there is a drop down box for the Ride that the inspection is for.
This is where the niggle is. This drop down box is connected to a query that searches for all rides that associate to the customer id. So it brings up a prompt to ask for the customer ID and then displays the results in a list when the query is ran itself.
On the actual form itself when i click on the drop down box for the ride, a Enter Parameter box appears to enter the Customer ID to find the rides and it shows in a list for the drop down which is cool, but he would like this to happen automaticaly.
Is there a way of the drop down box using the Number from a Different Field to get the ride information so it doesnt keep on asking for the ID when i click on the drop down box? Or is there a way of having the Parameter Field filled automatically?
Regards,
Mathew
Sorry about the wrong read just thought id need to explain what i needed.
Ive been creating a Database system for my mums partner's business. He is a thrill ride inspector, therefore he inspects rides you get in fairs. He has Customers Information and the customers rides. Everything is working great but there is one niggle that he would like to avoid.
I have created a form to Book Inspections, all works ok. I have fields that include Customer Id, Customer 1st name, Second name and then there is a drop down box for the Ride that the inspection is for.
This is where the niggle is. This drop down box is connected to a query that searches for all rides that associate to the customer id. So it brings up a prompt to ask for the customer ID and then displays the results in a list when the query is ran itself.
On the actual form itself when i click on the drop down box for the ride, a Enter Parameter box appears to enter the Customer ID to find the rides and it shows in a list for the drop down which is cool, but he would like this to happen automaticaly.
Is there a way of the drop down box using the Number from a Different Field to get the ride information so it doesnt keep on asking for the ID when i click on the drop down box? Or is there a way of having the Parameter Field filled automatically?
Regards,
Mathew