Display data to a datasheet form field automatically

[acnovice]

I have two tables and one form.

Table Form
1. tblCustomerOrderLog -- frmCOL (it is datasheet view).
2. tblCustomer has fields, CODE, PaymentTerms ...

On the frmCOL, I put CODE and PaymentTerms to display data.
CODE field is a combo box that I can choose the customer code.

My question is,
If I choose the CODE, I want PaymentTerms field display automatically as long as data in it.

I appreciate your help.

 

[TheAceMan1]

acnovice . . . . .

Are you saying you to [blue]show/hide[/blue] PaymentTerms acording to [blue]data/NoData[/blue] in the PaymentTerms?

See Ya! . . . . . .

 

[PHV]

Why not using the 3rd option of the Combo wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[acnovice]

TheAceMan1,

No. PaymentTerms will be showed always. If there's data in tblCustomer, it brings up. Otherwise, just blank.
It doesn't need to hide the column.


PHV,

If I use 3rd options of the Combo wizard, that will find a record on my form based on the value but I want to bring them from "tblCustomer".

I'm working on "frmCOL" and CODE and PaymentTerms come from different table which is "tblCustomer".

Can you give more info ?

 

[TheAceMan1]

acnovice . . . . .

[blue]When you select [purple]customer code[/purple] from the combobox and [purple]PaymentTerms[/purple] exist for that code . . . display [purple]PaymentTerms[/purple]. otherwise not . . . Yes![/blue]

If the above is true have a look at the [purple]DLookup[/purple] function . . .

See Ya! . . . . . .

 

[acnovice]

TheAceMan1,

Thank you for the answer.
I fixed it using DLookup function as you said.