I'm super stumped on this one! I have a few templates that I use and one is for a continuous form. I've used it many times and it works fine. I am trying to use it to build a very simple summary form. I have a table tblInvBank which I have cut down to the bare bones and it only has two fields; IDBank and BankName. I have some test data in the table.
The recordsource for my form is as simple as can be;
SELECT tblInvBank.BankName
FROM tblInvBank;
I have one control in the detail section of the form which is txtBankName whose control source is BankName. If I run the query from the Query Builder I get the results I would expect--a list of Banks. But on the form nothing shows up. I have made sure that the Control's Visible property is set to yes, and have a border set so that I could at least see a list of blank borders if the problem was some sort of color formatting that made text invisible. If I create a blank form from scratch it works right away, so I am assuming it has something to do with the form, especially because the query runs without a problem in the query builder.
Any Ideas? --As always thanks in advance
The recordsource for my form is as simple as can be;
SELECT tblInvBank.BankName
FROM tblInvBank;
I have one control in the detail section of the form which is txtBankName whose control source is BankName. If I run the query from the Query Builder I get the results I would expect--a list of Banks. But on the form nothing shows up. I have made sure that the Control's Visible property is set to yes, and have a border set so that I could at least see a list of blank borders if the problem was some sort of color formatting that made text invisible. If I create a blank form from scratch it works right away, so I am assuming it has something to do with the form, especially because the query runs without a problem in the query builder.
Any Ideas? --As always thanks in advance
Last edited: