Auto fill

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a database for engineering projects for work. I have a
table created for project info, and project status. I was wondering if there
is a way of automatically filling in the project numbers and names from the
project info table into the Project status table?

or is there one already made???
 
There is lots of ways of doing it, it all depends upon how you're designing
it.

One method is on the combo box that you're using to select the project name,
include status and other info. then use comb.column(x) to grab the name

if combo.rowsource = Select ID, ProjName, ProjStatus, from project

then combo.column(1) = ID
combo.column(2) = project name
combo.column(3) = status
 
Column is a zero-based property, so the first column is actually .Column(0),
the second column is .Column(1), etc.
 
Back
Top