G
Guest
I have a combo box and a text box in access that will not keep the info when i go to the next page...i am at a complete loss..please help!
G
GVaught
You need to give us more information. Is the combo box attached to a
different table or query? Is the textbox bound or unbound. Unbound will not
remember your information. Bound textboxes will. Bound textboxes are
attached to a field in a table or query. If the textbox is attached to a
query, is the query considered updateable. Updateable queries will remember
you data. Unupdateable queries will not.
--
G Vaught
different table or query? Is the textbox bound or unbound. Unbound will not
remember your information. Bound textboxes will. Bound textboxes are
attached to a field in a table or query. If the textbox is attached to a
query, is the query considered updateable. Updateable queries will remember
you data. Unupdateable queries will not.
--
G Vaught
when i go to the next page...i am at a complete loss..please help!SLAM said:
G
Guest
I am pretty new to this, please be patient...on my form i have a text box that appears to be unbound. I do not beleive it is attached to a different table or query...does that make sense?
G
GVaught
When you create a form it should be based on a table or query that you have
created in order for data to be saved to that table. Tables store your data
for later retrieval and permanent reference. If you create a form and never
attach it to a table or query, it will not know where to save your data.
I am assuming that you have created some type of table first in your
database. If you have no tables, then you need to create one first. Having
said this, you really need to do this first: I would purchase a book on
MSAccess. Access is the one program in the Office suite that you should get
educated on via a book. If you design a database wrong, it will haunt you
for the rest of your life. Word. Excel, PowerPoint are programs that you
don't need a book to learn. Creating a database you do.
--
G Vaught
created in order for data to be saved to that table. Tables store your data
for later retrieval and permanent reference. If you create a form and never
attach it to a table or query, it will not know where to save your data.
I am assuming that you have created some type of table first in your
database. If you have no tables, then you need to create one first. Having
said this, you really need to do this first: I would purchase a book on
MSAccess. Access is the one program in the Office suite that you should get
educated on via a book. If you design a database wrong, it will haunt you
for the rest of your life. Word. Excel, PowerPoint are programs that you
don't need a book to learn. Creating a database you do.
--
G Vaught
info when i go to the next page...i am at a complete loss..please help!SLAM said:
G
Guest
In that case, you will have to bound the fields, both the combo box and the text field to a table or a query where you want the info to be stored. Actually, when you created the combo box, didn't it asked where you wanted the info to be stored?
G
Guest
BOTH THE COMBO BOX AND THE TEXT FIELD ARE CONNECTED TO A TABLE..SO HOW DO I 'BOUND' THE ABOVE?
G
Guest
Go to the properties of both fields. Then go to the control source of the properties. Choose the field from the table. It's trickier with the combo box. I normally just redo the combo box and let the computer write the query for me. What can I say. I am lazy.