By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,383 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

An old form name that comes back

100+
P: 158
Ok, I am confused with something unusual that I have never encountered before.
I picked up a sample inventory database online and integrated it into my database as a module. Everything worked fine.

The thing that I am having trouble with is this:
I renamed a form that used to be called: Transaction list

I use this form twice as sub-form in two different place and gave it two different names: PurchaseTransactionDetails and InventoryDeploymentDetails.
Worked great and I was happy.

After a while and after many new entries with new inventory items I started to get a longggggg list of Inventory Items and it was time to shrink or filter this combo box so it would only show the inventory items that are part of a certain Category.

So I created a dynamic combobox InventoryItem with a category filter query as its control source.

So when it was time to go into the Expression Building to pick up a reference address to paste under my category field in my qbe query I noticed that the address that I pasted had changed into the original name of what the form used to be called “Transaction List.” How is that possible?

Expression Builder clearly show the form as being “PurchaseTransactionDetail” but when I paste it into my query it changes into “Transaction list”????????? and obviously creates problems when I click the category field in my form.
Any ideas?
Feb 14 '10 #1

✓ answered by missinglinq

This is a problem that we hear about, from time to time. The answer, I believe, is to import all objects into a new, blank database, delete the old db, then rename the new one to the original name.

Linq ;0)>

Share this Question
Share on Google+
2 Replies


100+
P: 158
Adendum:

I've managed to somehow make one of the subform with the dynamic combo box work. don't ask me how this is possible because the reference refers to a form that doesn't exist anymore but it works nevertheless. I've gone line by line to try to reproduce what I did in one of the sub form and it doesn't work. I should have became a mechanic! #&@%!!!!!
Feb 14 '10 #2

missinglinq
Expert 2.5K+
P: 3,532
This is a problem that we hear about, from time to time. The answer, I believe, is to import all objects into a new, blank database, delete the old db, then rename the new one to the original name.

Linq ;0)>
Feb 14 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.