Displaying Text on Form Depending on Another Field Box

[raychow22]

Hi Forum,

Is there a way to build a expression or make a calculated field where a text displays on a form due to another field box that is selected. I have a field for "NCR Detail" that will be selected and automatically the "NCR Code" will be displayed on the Header as illustrated. The relationship with NCR Detail and NCR Code is matched 1:1 on a Table. Not sure how to go about this. Thanks!

[CJ_London]

sounds like what you need is in your ncr code textbox put

=cboNCRDetail.column(1)

change names to match your names

[raychow22]

sounds like what you need is in your ncr code textbox put

=cboNCRDetail.column(1)

change names to match your names

Hey Ajax,

Thanks for the quick response. I used =cboNCRDetail.column(1) on the NCR text box on "default value" Form View and it comes out to be "=[cboNCRDetail].[column](1)" on the expression builder. This doesn't appear to work. Any other suggestions? BTW the table for the NCR codes and NCR detail is on a separate table by itself. I don't know how they can be linked up.

[raychow22]

I was thinking using Dlookup....But was unsuccessful... This is what i tried so far

=DLookUp("[tblNCRCode1]![Code]","[tblNCRCode1]",[tblNCRCode1]![Description]=[cboNCRDetail])

[CJ_London]

default value is only applied for new records - it needs to be in the controlsource

[raychow22]

Ajax,

This almost worked; It displays the "type" from the above text field but not the actual "code". When I change from "1" to "0" it displays the "details".

[raychow22]

Here's another pic

[CJ_London]

it depends on the columns in your rowsource - you haven't provided any information about that - the implication is you wanted pick up the displayed value which is usually column1

[raychow22]

Thanks Ajax,

I just used dlookup instead for this.

[raychow22]

If the field is just a text box then it wouldnt have a rowsource, correct? Id have to use a combobox or list box?