Empty form textbox on open


J

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?
 
Ad

Advertisements

Ad

Advertisements

J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top