Auto fill in field on Form that's opened by query?

  • Thread starter Thread starter meilu
  • Start date Start date
M

meilu

This should be a pretty easy question.. I'm jot not
creative enough to see the solution.

I have 3 forms Factory, Vendor and Contact

Contact has two fields which I would like to have auto
filled. EntityType & EntityName

Contact is opened when a cmd button on Factory/Vendor is
pushed.

Obviously:
EntityType is 'Factory/Vendor'. EntityName is the Name of
the Entity.

I think it's too redundant to have to refill these fields
in when their value is obvious. Is there anyway to auto
fill these fields?

Any help would be great!
Meilu
 
I have 3 forms Factory, Vendor and Contact
Click to expand...

Forms ARE JUST WINDOWS. I presume you have Tables behind these
forms... right? If so, the data is in the Tables... *not* the forms.
Contact has two fields which I would like to have auto
filled. EntityType & EntityName
...
I think it's too redundant to have to refill these fields
in when their value is obvious. Is there anyway to auto
fill these fields?
Click to expand...

Obvious from... what? How do you determine the EntityType and
EntityName based on the value of a Contact? Are you storing these
fields redundantly in two tables? If so... *don't*.

You can *display* the values corresponding to a selected value, by
using a Query or by setting the control source of a textbox to

=comboboxname.Column(n)

where comboboxname is the name of a Combo Box which includes the
fields, and (n) is the zero-based subscript of the field in the
Combo's rowsource query.
 
Back
Top