Fill in cells automatically

  • Thread starter Thread starter IT in distress
  • Start date Start date
I

IT in distress

I need to know how to make access automatically fill in a
group of related cells automatically when given specific
criteria. i.e.: We have a project database that contains
project name, project number and project client. If I
select a name of a project I want access to automatically
display the number and the client.

If anyone could please help it would be greatly
appreciated.

IT in distress.
 
I have a feeling that you will want a touch more help than
this, but a combobox has the capability to display the
ProjectNumber, Client, etc.. when you type in the
ProjectName.

Now, do you want it to go to that record??? Not sure what
you mean when you say "make access automatically fill in a
group of related cells automatically when given specific
criteria"

Gary Miller
Sisters, OR
 
" fill in a group of related cells" That makes me think that maybe your
solution may be a better table design. Normally (pun intended) you would
not want to fill in additional "fields" based on the value in one field.
Good normalized table design would normally eliminate it.
 
Back
Top