Solved I need help in DLookup (1 Viewer)

[arnelgp]

here, you check and test your form.

 

[Khurramshaikh47]

here, you check and test your form.

Thank you arnel. I'll let you know. Just give me some time to reach home. Travelling...

 

[Khurramshaikh47]

here, you check and test your form.

Its ???-???-???? instead of COACODE.

 

[arnelgp]

what is the use of the Combobox on the COACODE?
if you are not going to use that combobox, better to disable it and
change it to ordinary textbox.

try again.

 

[arnelgp]

Start your application from scratch, because it already has a lot of bugs and problems, although it is not yet a real application.

there are 2 main tables i see, one is main account and the other is sub-accounts
the "detail" accounts are being built around these 2 tables (or on 1).
are you a "certified" accountant to say that this is a bug?

 

[Khurramshaikh47]

there are 2 main tables i see, one is main account and the other is sub-accounts
the "detail" accounts are being built around these 2 tables (or on 1).
are you a "certified" accountant to say that this is a bug?

I wanted that when the user writes the name of the account and selects its subcategory, its main category and a unique code to be automatically generated.

 

[Khurramshaikh47]

what is the use of the Combobox on the COACODE?
if you are not going to use that combobox, better to disable it and
change it to ordinary textbox.

try again.

Its working perfectly.

Thank you so much arnel.

 

[ebs17]

are you a "certified" accountant

No. Are accountants the better database developers?