Form programming

  • Thread starter Thread starter marnita F via AccessMonster.com
  • Start date Start date
M

marnita F via AccessMonster.com

Hi Guys,

I need to creating a form that has a combo box to select company names from
the list and I need to use the NotInList Event to add names. Then I need 4
fields to auto populate. This also needs to be data entry and edit form.
The auto populated fields will be the same for every new or old record
because they are titles.
example:
Company for combo box
auto populate the fields listed below:

VP = John Jones
Senior VP = Paul Adams
Received = Lisa Evans
Processed = Lisa Evans

Thanks for any help you can give me!
 
Hi Guys,

I need to creating a form that has a combo box to select company names from
the list and I need to use the NotInList Event to add names. Then I need 4
fields to auto populate. This also needs to be data entry and edit form.
The auto populated fields will be the same for every new or old record
because they are titles.
example:
Company for combo box
auto populate the fields listed below:

VP = John Jones
Senior VP = Paul Adams
Received = Lisa Evans
Processed = Lisa Evans

Thanks for any help you can give me!
Click to expand...

I'm not sure I understand. Are you storing the names John Jones, Paul
Adams, Lisa Evans redundantly in *EVERY RECORD*? That sounds like
improper normalization to me. What Table is the rowsource of this
combo box, what are its fields, and what do you need autopopulated?

John W. Vinson[MVP]
 
Sorry

I guess it does sound like that. Sorry for not being clearer in my
explanation. What I have is a form that will hold this information. There
are 50 vias currently but we are always adding more. The person who received
the via paperwork will always be the same person. That also goes for the
person reviewing the via paperwork, contribution model, VP, and senior VP.
This is why I would like these names to be a constant. The updating is in
the received, review, contribution model, VP, Sr VP dates. These people all
represent different stages in the Via process. So basically. I just need to
know how to have these field auto populate for the existing via and for any
new record. Also how can I have a combo box lookup items in this form, add
new and perform notinlist event.

Thanks for any help you can provide me



John said:
Hi Guys,
Click to expand...
[quoted text clipped - 13 lines]
Thanks for any help you can give me!
Click to expand...

I'm not sure I understand. Are you storing the names John Jones, Paul
Adams, Lisa Evans redundantly in *EVERY RECORD*? That sounds like
improper normalization to me. What Table is the rowsource of this
combo box, what are its fields, and what do you need autopopulated?

John W. Vinson[MVP]
Click to expand...
 
Sorry

I guess it does sound like that. Sorry for not being clearer in my
explanation. What I have is a form that will hold this information.
Click to expand...

No. You don't.

Tables hold information. Forms are just tools, windows which let you
manipulate the information in tables.
There
are 50 vias currently but we are always adding more. The person who received
the via paperwork will always be the same person. That also goes for the
person reviewing the via paperwork, contribution model, VP, and senior VP.
This is why I would like these names to be a constant. The updating is in
the received, review, contribution model, VP, Sr VP dates. These people all
represent different stages in the Via process. So basically. I just need to
know how to have these field auto populate for the existing via and for any
new record. Also how can I have a combo box lookup items in this form, add
new and perform notinlist event.
Click to expand...

Again... I don't understand your table structure. Let's be sure that's
right before we spent too much effort on the Form!

What is the Form's Recordsource?
What is the structure of this Table?
What is a "via" - you obviously know the term but I don't.
If the names are a constant, does that mean that nobody at the company
is ever allowed to retire, resign, be fired, or die?
It still sounds like you're storing a LOT of redundant information,
and that you may want to consider a better structure!

John W. Vinson[MVP]
 
Back
Top