Two quick questions on input box and autofill

[BrazilTechie]

Hello everyone:

I know it's been a while I had to deal with MS-Access programming...

1) How do I capture a date from a form into my code the same way I would with a inputbox?

2) How do I automatically fill a control_1 based on a control_2 in the same form (based on table1).

Thanks in advance for your help.

 

[SnaveBelac]

I think this is what you are asking...

1) To read the value of any control on a form use:

Forms!form_name!control_name

2) To copy the value of one comtrol to another

Forms!form_name!control_2 = Forms!form_name!control_1

This code can be attached to the afterUpdate event of control_1

Hope this is what you wre looking for. If not, post again.

----------------------------
SnaveBelac - Adventurer
----------------------------

 

[PHV]

You really don't have F2 nor F1 key on your keyboard ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Crowley16]

maybe he didn't install help...