Hi,


I have a form to display a table T in a neat manner in a database. The form is also intended to be exported into (and used in) other databases which have almost identical structure. The only difference is that some fields in T are not present in the other databases. So, naturally, Access annoys users with "Enter Parameter Value" dialog box each time the exported F is updated.
Now, I do not want users to be bothered with the dialog box and I don't want them to modify the form. The goal is to make things work so that users only need to export the form into another database and simply use it without obstacles.

I tried putting
Code:
=Iif( FieldExists("fld","T"), [fld], "")
into the FLD textbox. However, this does not solve the problem when F is used as a subform (which it is, I must confess). Each time another record has to be displayed, the Enter Parameter Value pops up (one for each missing field of course).
Isn't there a way to supress them... once and for all?

Any opinions welcome (constructive even more)

wiggles

PS: That "FieldExists" is a VBA function I found on the net.