Empty form textbox on open

[Julia]

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?

 

[boblarson]

How are you filling in those two fields, normally?
--
Bob Larson
Access World Forums Super Moderator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Julia]

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.