Is this a known issue?

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I've had this on several apps I've developd.

I've got a database, about 10 tables, several forms
accordingly. On 1 form (to add account information, as
soon as I close and save the form, I get a parameter
request come up, asking for a value of a combo box on
that form.

This is wrong - I'm not asking for a parameter anywhere,
and anyway, the combo box has a value. So why the message?

Is this a known issue? I've had it before - sometimes
closing the db and re-opening kills it for a while, but
its come back. Compact / Repair makes no difference
either.

TIA tim
 
It sounds as if either the table name, the field name, or the query name the combo box is linked to has changed. Check the rowsource and the control source for this change. Also if the form is linked to a query check the field in the query and make sure it doesn't say something like Expr1: Table.field
 
Thanks for the responses but the answer is 'non of the
above'

The form is based on table, not a query (but forms Ihave
based on querys dont do this)
The Combo-boxes are using a select statement to define a
foregin key (in this case account - country - the combo
selects the country the account resides in)
There are no 'Expr' fields anywhere
No names have changed
No links have been dropped.

Its tempremental - only happens every couple of uses,
hence why this is a weird one.

Any more ideas?
TIA
tim
 
I can't think of anything else unless you have the required value set to yes and the value was left blank. Does it only happen at runtime or does it do it when you save the form in design view? Does it only happen when you close the form and not when you open it? The parameter value it ask for, is the field name from the table or the select query of the combo box?
 
Back
Top