Forms!frmCustomer!txtCustomerFilter

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

Dea All,
last year I fond in internet a very useful and beautiful address book form,
that I adjusted to my needs. Last week, on request, I had to insert a new
field (Location) and now while pushing the Close button, in order to quit
the form, a little input window appears asking: Parameter Value:
Forms!frmCustomer!txtCustomerFilter

This beautiful form is a part of database used for sending samples to the
customes, and it is a useful tool.
I am afraid that the problem is in the double copy of the Customer field,
such as

Customer: Alpha Ltd Alpha Ltd
Address1: Regent street, 4 Apaloosa Road, 5
Address2: London Austin
Address3:
Address4:

Location: London Texas
Country: United Kingdom United States of America
Fao: Mrs. Katy Smith Mr. Robert Swift


but I don't know how to solve the mistake/problem.
Thanks in advance for any kind of help!
Kind regards,
Marc
 
When you presss the "Close" button some code runs. The code is triggering a
query somehow and the query needs a value held in a control called
txtCustomerFilter on a form called frmCustomer

Either the form does not exist, or the control txtCustomerFilter does not
exist.
 
Thank you very much for your answer John , I carefully read your reply, but
unfortunatelly I don't know
how to solve the problem yet. The Close button code has a simple code,
created by the wizard, see above:

Private Sub cmdExitCustomer_Click()
Me.Refresh 'Added by myself in order to refresh new costumer entry
On Error GoTo Err_cmdExitCustomer_Click
DoCmd.Close
Exit_cmdExitCustomer_Click:
Exit Sub
Err_cmdExitCustomer_Click:
MsgBox Err.Description
Resume Exit_cmdExitCustomer_Click
End Sub

However a query, situated under a list box in the form, has this kind of
filter:
Like [forms]![frmCustomer]![txtCustomerFilter] & "*"

This kind of "error" is shown when many customer records are present in the
form/table, can this help you?
The form is the most beautiful and usefull I ever saw, believe me, and it's
a pity that it
doesn't perfectly work .

Anyway, thank the same your your time!
Kind regards,
Mark
 
Back
Top