If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Empty form textbox on open
Hi,
I restructured my database and now I find that the data in two textboxes does not display when the main data entry form loads or is in focus after a different form has been opened. The data in the textboxes used to be in the table that the form is based on, however I split this off into another table. The textboxes look up data in the new table based on the selection in a combobox. The textboxes are empty when the form loads. If I scroll to the next record and go back, the textboxes are filled. I have tried to requery or refresh the textboxes when the form loads or has focus but without success. It is not a big problem but I think it will look confusing for the users if they load the form and there is no data for the two textboxes. Can someone let me know what I am doing wrong? |
#2
|
|||
|
|||
Empty form textbox on open
How are you filling in those two fields, normally?
-- Bob Larson Access World Forums Super Moderator Tutorials at http://www.btabdevelopment.com __________________________________ "Julia" wrote: Hi, I restructured my database and now I find that the data in two textboxes does not display when the main data entry form loads or is in focus after a different form has been opened. The data in the textboxes used to be in the table that the form is based on, however I split this off into another table. The textboxes look up data in the new table based on the selection in a combobox. The textboxes are empty when the form loads. If I scroll to the next record and go back, the textboxes are filled. I have tried to requery or refresh the textboxes when the form loads or has focus but without success. It is not a big problem but I think it will look confusing for the users if they load the form and there is no data for the two textboxes. Can someone let me know what I am doing wrong? |
#3
|
|||
|
|||
Empty form textbox on open
I have this expression in the textbox: =cboSite.column(1)
So the combobox cboSite shows the site name, then column 1 contains the country that the site is in. "boblarson" wrote: How are you filling in those two fields, normally? -- Bob Larson Access World Forums Super Moderator Tutorials at http://www.btabdevelopment.com __________________________________ "Julia" wrote: Hi, I restructured my database and now I find that the data in two textboxes does not display when the main data entry form loads or is in focus after a different form has been opened. The data in the textboxes used to be in the table that the form is based on, however I split this off into another table. The textboxes look up data in the new table based on the selection in a combobox. The textboxes are empty when the form loads. If I scroll to the next record and go back, the textboxes are filled. I have tried to requery or refresh the textboxes when the form loads or has focus but without success. It is not a big problem but I think it will look confusing for the users if they load the form and there is no data for the two textboxes. Can someone let me know what I am doing wrong? |
Thread Tools | |
Display Modes | |
|
|