Search results

If my assumption is correct - you save the new customer in the CopyRecord - so after, just before the end of the Sub, you can Combo59.Reqyery

The simpliest was is to actually requery the combo that has the customer name - so after you save the customer, you then do cboCustomer.Requery. If the Row Source property of the combo box does not have the query and you do the query seperately, you will have to run over your query and then...

I don't think you are doing anything wrong - it is just the Math. You will have to incorporate the IIf() function. If the birthdate is greater that the present date you will just have to switch around the dates in the DateDiff function - so you would get the negative sign. SO don't panic!!

Thanks for your response - I am now just trying to figure out how best to use the parameters. I cannot prompt the user for the values - I will have to split it up myself because they are queries on quite a great number of pieces of equipment. Thanks again

Thanks for your replies - I am about to download the examples. The thingis as well that I do need all the results to be returned to me - so even though I can limit the number of columns by the criteria - I still want all the results returned.

Hi, I am not sure that I even asked this question correctly - but my problem is that I have too many records in a crosstab query and I do not know how to effectively split it. I can possibly just do some at a time, but I don't want to limit the query - that is - if more pieces of the equipment...