Problem importing forms

[mouldh]

I have updated my copy of a database which included updates to a number of forms. I now want to import those changes into the proper database, so I used the Import function. I didn’t get any errors when I imported everything, but the forms do not work as they did in my copy of the database.
One of the forms that don’t work comprises of a number of drop down boxes, I have updated these so that the user has a filtered selection, to do this I put an SQL function in the Row Source property. This SQL function has been copied over correctly in the imported form, in fact when I go into the form in design view to check this fact then revert it back to normal view (after having not changed anything) it then works – and all the other drop down boxes that didn’t work on that form now work! How can viewing a form in design view and not changing anything make it now work?
So I could go into each form in the design view, check the Row Source property, then revert back to normal view and it would solve the problem of my forms not working, but, this database that I am importing the forms into is the back end of a split database and the first thing that the front end of the database does is import the changed objects into its database – but the forms don’t work.
I have made changes in this way before and not had any problems before.
Have you any ideas as to what I am doing wrong please? I am using Access 2003.
Thanks.

 

[Pat Hartman]

Welcome aboard
A better solution is to completely replace the FE when you update it.

Something about opening the form in design view is causing Access to recognize it. It is always a mystery to me when stuff like this happens because it is clearly a bug and that bug will never get fixed because it is too obscure and not encountered enough to raise its importance.

Try opening the form in design view after you import it and then close and save it. You can do this with VBA.

An alternative is to use a querydef in the RowSource fields. If you do that, make sure you import the querydef before you import the form.

 

[mouldh]

Thanks for your reply.

I don't want to have to completely replace the FE every time I update it, but it looks as if I may have to this time.

I have tried it with a querydef in the RowSource fields, but I get the same result (I imported the query before the form as well).

I could try your suggestion of opening the form in design view after I have imported it. Could you give me a hint of how to do that with VBA please?

I am not in work today, so will not get chance to try this till tomorrow at the earliest.

Thanks again.