Enter parameter value

[John]

Hi,
I have built a small database with three tables and two input forms.
I had to modify my original design and delete two columns from the tables
and their associated input list boxes. Now when I click to open the main
form a small input box pops up with "Enter parameter value" as its heading
and over the input box has something like "Payments.CreditCard" on it.When I
hit enter a second one pops up with similar features except its
"Payments.CardHolder".If I hit enter then it closes and things work as
normal.How do I get rid of this problem.......its more a nuisance than a
major problem, but looks bad. Tia John

 

[John Vinson]

Hi,
I have built a small database with three tables and two input forms.
I had to modify my original design and delete two columns from the tables
and their associated input list boxes. Now when I click to open the main
form a small input box pops up with "Enter parameter value" as its heading
and over the input box has something like "Payments.CreditCard" on it.When I
hit enter a second one pops up with similar features except its
"Payments.CardHolder".If I hit enter then it closes and things work as
normal.How do I get rid of this problem.......its more a nuisance than a
major problem, but looks bad. Tia John

Open the Form in design view. Check to make sure that you're not
referring to these two fields anywhere on the form: textboxes, in the
Form's Order By property, Master or Child Link Field properties of a
subform, or elsewhere. Also check the Form's Recordsource property: if
it's not just the name of the table, click the ... icon to open the
query in design view. If these fields are still in the query, delete
them.

John W. Vinson[MVP]