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.

 

[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.