Link to home
Start Free TrialLog in
Avatar of Sandra Smith
Sandra SmithFlag 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.
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

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

mx
Avatar of 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.
Let me clairfy, I did not rename the control sources with the txt prefix, I renamed the Name of the control
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
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.
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.
Hummm ... ok ... trying to reproduce the issue ...

mx
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
I tested creating a new form following the same procedures as I originally did, and it is working fine again.