Form Name and Caption

[RECrerar]

Hi something I was not expecting has just happened

I have two form which both have a filter by form functionality. There are two of them as one is quite limited as it was my first attempt and the other is has much graeter flexibility. I originally thought of just idscarding the practice one, but have since thought that it would be nice to keep the two and use them a bit like printer options, where it opens up with teh simple form and then you can click a [Go Advanced] button to bring up the better form.

the forms are called "frmFlexibleComparisms" (simple one) and "frmAdvancedFlexible"

This was all working fine. However when I liked the two forms things started to go a bit odd.

1. It has saved another version of the advanced form, calling it by the form caption

2. On the original version, all the VBA behind the form has disappeared (it is all still there in the new version

3. It will not let me rename the original version (I was thinking of just calling this "frmAdvancedflexible_bak" and calling the other frmadvancedflexible to test if the database will work with the other version of the form before deleting the original)

Does anyone know why this has happened and what I did to cause the situation?

Sorry if this is not that clear but I don't really understand it myself

Regards
Robyn

 

[DCrake]

What version of Access are you using?

Is it possible to post the sample db?

David

 

[RECrerar]

Hi,

I'm using Access 2003. I can't really post the database as it's got a lot of company data in it, but everything seems to be working now. I deleted the old form with all the VBA missing and renamed the new one (the one that took the caption as its name) and everything seems to be behaving as expected.

Still not sure what happened but unless it happens again I'm happy to but it down to a human error that I didn't realise I did

thanks for the interest though