Populate text boxes with hidden combo box columns

W

winsa

Hi

I have a combo box (cbo_REF) on a subform of which the Recordsource is
controlled by a combo box (cbo_DEBTOR) on the main form. There are 8 columns
in the underlying SQL query, but only 4 of them are actually visible in
cbo_REF. I have two questions.

Firstly, is there any way to populate the text boxes on the subform with the
hidden combo box column? I have tried using =[cbo_REF].Column(4) in the
ControlSource of the textbox, and that seems to work for those columns that
are showing, but not for the columns that are hidden.

Second, how can you control the format of the data that populates the text
boxes? ie. one of my text boxes should show a monetary amount (text box set
to Currency Format), but it just displays an integer.

Thanks in advance for any help.

Regards
Winsa
 

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

Similar Threads

auto populate text box based on combo box value 1
Combo Box not displaying 2
Automatically generating text entries from combo box 4
Combo box tied to a specific cell 4
Continuous Form - Populate unbounded field 1
sum combo box based on other combo box 2
How do I control a text box via another combo box 2
Trouble Filtering a Sub Form With Combo Box Options 2

Top