Avatar of Sandra Smith
Sandra Smith
Flag for United States of America asked on

Some text boxes on Unbound form not appearing in intellisense

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.
Microsoft ApplicationsMicrosoft DevelopmentMicrosoft Access

Avatar of undefined
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

8/22/2022 - Mon
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

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

mx
Sandra Smith

ASKER
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 Smith

ASKER
Let me clairfy, I did not rename the control sources with the txt prefix, I renamed the Name of the control
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

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 Smith

ASKER
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 Smith

ASKER
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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

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

mx
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Sandra Smith

ASKER
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 Smith

ASKER
I tested creating a new form following the same procedures as I originally did, and it is working fine again.
Your help has saved me hundreds of hours of internet surfing.
fblack61
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Guess we got lucky.

mx