Subform Text Box Values

[wcboyd]

Hello All,

I have a subform that I want to display values other than the key field in.

For example,

One of the fields on the subform is location. It is a plain text box. It displays the value of 5645 instead of "334 Greenbriar Road". 5645 is the key value stored in the db, but that is not very user friendly. So how do display something more helpful? This form is essentially just an Inquiry screen.

Thanks,

Craig

 

[mresann]

I don't really have enough information, but I will make the assumption that the underlying recordset (either query or table) for the subform includes the fields "Location" (with the uniquie number identification), and "Address". If your underlying recordset doesn't contain both fields, create that first and then go to the next step.

Now, create a textbox on the subform called "txtAddress". Bind that control to the column or field called "Address". Size and display it in the place you need to display it.

Next, click on the "Location" text box. In the Properties box, under Visible, click "False".

You should now be able to see the Address, rather than the location, but the location textbox will still be able to be accessed from anywhere in the application if you need the value for query purposes.

Again, this is down and dirty, but will work without flaw.

 

[wcboyd]

mresann,

Thanks. I gave that it a try and it works nicely.