General discussion

Locked

Access:Have 1field autofill another?

By jpadilla ·
My form has 6 fields and all but 1, have data input via ten-key pad. Is it possible to have one field entry auto fill another (e.g. "MainDTCode"=24 "Code"=Set) without requiring alpha key entry or a "List Box"?

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by saratogapete In reply to Access:Have 1field autofi ...

Sure you can!
If you use the AfterUpdate event on any of your text box controls you can put a macro or VBA code there to do what you want. FOr example, if they type "MainDTCode" in TextBox 1, you could have code like:
If me.textbox1 = "MainDTCode" then
me.OtherTExtBox = 24
endif
THat's a very simple example but that's the gist of it.

I hope this helps.
Peter

Collapse -

by jpadilla In reply to

Pointed me in the right direction :0)
As my code writing skills are minimal, I will re-post in hopes of acquiring specific code for my situation.

Collapse -

by jpadilla In reply to

Pointed me in the right direction :0)
As my code writing skills are minimal, I will re-post in hopes of acquiring specific code for my situation.

Collapse -

by jpadilla In reply to Access:Have 1field autofi ...

FieldName "MainDTCode" is set for DATA TYPE=text and limits the input range (1-999). I am currently utilizing 1-165 of the range.
Each one the those entries requires a corresponding "Code," limited to only: MTN,PRO,OTH,SET and RAW.
Will this require a macro or VBA code unique for each possiblity?

Collapse -

by jpadilla In reply to Access:Have 1field autofi ...

FieldName "MainDTCode" is set for DATA TYPE=text and limits the input range (1-999). I am currently utilizing 1-165 of the range.
Each one the those entries requires a corresponding "Code," limited to only: MTN,PRO,OTH,SET and RAW.
Will this require a macro or VBA code unique for each possiblity?

Collapse -

by jpadilla In reply to Access:Have 1field autofi ...

This question was closed by the author

Collapse -

by jpadilla In reply to Access:Have 1field autofi ...

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums