|
Hi.
I have a form that contains a combo box with customer number & customer
name in it. The form is called F_DeleteUSCust and the
combo box is named CB_getUScust
It picks up the information for Row Source from a distinct query.
I have the column count as 2 and bound column 1 (saving customer
number).
I have 2 buttons on the form, one to preview the transactions for the
save customer from the combo box and one to delete all the customers
from the combo box.
The "on click" inside the buttons call a macro which opens a query ...
one to preview and one to delete.
The sqls are
SELECT [US 60 days past due].[ID], [US 60 days past due].[Collector
Name], [US 60 days past due].[Customer], [US 60 days past
due].[Customer Number], [US 60 days past due].[Transaction Number], [US
60 days past due].[Transaction Date], [US 60 days past due].[Due Date],
[US 60 days past due].[Transaction Balance Due SUM]
FROM [US 60 days past due]
WHERE ((([US 60 days past due].[Customer
Number])=[forms]![F_DeleteUSCust]![CB_getUScust]));
and
DELETE [US 60 days past due].ID, [US 60 days past due].[Collector
Name], [US 60 days past due].Customer, [US 60 days past due].[Customer
Number], [US 60 days past due].[Transaction Number], [US 60 days past
due].[Transaction Date], [US 60 days past due].[Due Date], [US 60 days
past due].[Transaction Balance Due SUM]
FROM [US 60 days past due]
WHERE ((([US 60 days past due].[Customer
Number])=[forms]![F_DeleteUSCust]![CB_getUScust]));
Every time I run the form, when I click on the button, it gives me the
"ENTER PARAMETER VALUE" forms!F_DeleteUSCust!CB_getUScust
If I enter a value, then the query works.
Does anyone know how to fix it?
I also tried running the ANALYZE / DOCUMENTER on the form and receive
"application error or object defined error". Which is ambiguous.
Thanks for any/all help.
Karen
| 
