Help with Access, please!

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hello,

I need some help with Access. Anyone who can help, please
don't hesistate to post a response for me. Here's the
problem:

I have a form that I am creating. The form will contain
numerous fields for data entry. There are two fields that
I am stuck on. Let me explain, one of the fields is a
drop down menu with codes taken from a table i created.
Now, the other field is a 'code description field' I am
trying to have the descriptions of the codes appear in the
code description field when i choose a code from the drop
down menu from the previous field. am i making sense?
basically, if you choose a code from the drop-down menu in
the "code" field, i want the description of that code
(which was chosen) to appear in the other field
called, "code description."

if anyone can help me out, it will be greatly
appreciated.
thanks
alex
 
Alex said:
Hello,

I need some help with Access. Anyone who can help, please
don't hesistate to post a response for me. Here's the
problem:

I have a form that I am creating. The form will contain
numerous fields for data entry. There are two fields that
I am stuck on. Let me explain, one of the fields is a
drop down menu with codes taken from a table i created.
Now, the other field is a 'code description field' I am
trying to have the descriptions of the codes appear in the
code description field when i choose a code from the drop
down menu from the previous field. am i making sense?
basically, if you choose a code from the drop-down menu in
the "code" field, i want the description of that code
(which was chosen) to appear in the other field
called, "code description."

if anyone can help me out, it will be greatly
appreciated.
thanks
alex
Click to expand...

Best to ask in the groups specialising in access, e.g.
microsoft.public.access.*
 
Post your question at:

microsoft.public.access.forms

or

microsoft.public.access.formscoding
 
Hi Alex,

If you are talking about another field in the same table, then all you need to do is refresh the field.

If you are talking about a field in another table, you need to set up a relationship and set referential integrity.

Ciao . . .
C.Joseph

++ Let know man judge me until . . .
he has walked the road I have . . .
in the shoes I've worn. ++

http://kalek1.home.mindspring.com
 
Back
Top