Some text boxes on Unbound form not appearing in intellisense

Sandra Smith
Sandra Smith used Ask the Experts™
on
I have a form that I initially created with the form wizard based on a table so would be sure to capture all the approrpiate fields.  I delete the control source and renamed all the text boxes from their original column names to the column name plus txt.  That is, Tast control is now txtTask.  However, none of these text boxes appear when I write the vba to update back to the table.  That is, when I set, say rst!Task = Me.txtTask, txtTask does not appear and it says it does not exist.  However, if I create a fresh text control and rename it, then it does appear.  I doh't want to have to create all these text boxes and I simply do not understand why they would not appear.  I cleared the record source for the form as I want it to be unbound until the save code is run.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
But, if it is an unbound Form, then what were these Control Sources ?

mx
Sandra SmithRetired

Author

Commented:
Orginally, the control sources were the table as I wanted to be sure to capture all the columns.  I then clearned the control sources for each text box and renamed with the "txt" prefix.  I also cleared the control source for the form.
Sandra SmithRetired

Author

Commented:
Let me clairfy, I did not rename the control sources with the txt prefix, I renamed the Name of the control
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
I understand.  So, right now for example you have a Text box named txtTask ... and in vba, you do not get

Me.txtTask in Intellisense, correct ?

Can you upload a db that does this?

mx
Sandra SmithRetired

Author

Commented:
I am at a financial institution and am blocked from uploading data.  You know, I had this very same problem a couple of years ago and I think you solve it at that time too.  I just can't find the original question.
Sandra SmithRetired

Author

Commented:
Yes, you are correct, I do not get the Me.txtTask in intellisense.  Only if I delete the control and create a new text contol and then name it txtTask does it show up.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Hummm ... ok ... trying to reproduce the issue ...

mx
Database Architect / Application Developer
Top Expert 2007
Commented:
Well, I did exactly (I think) what you did ... wizard, etc ... and I cannot reproduce the problem.  I see txtField1 in intellisense.

Can you try a Compact & Repair ?

Actually, go into VBA editor >> Debug >> Compile

Does the app compile w/o errors?

mx
Sandra SmithRetired

Author

Commented:
Compact seems to take care of it.  Originally, when running the debugg complier, that is when I received the error that the object did not exist, but seems to be working fine now.  Thank you.
Sandra SmithRetired

Author

Commented:
I tested creating a new form following the same procedures as I originally did, and it is working fine again.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Guess we got lucky.

mx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial