Auto fill

[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???

 

[Guest]

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

 

[Ken Snell \(MVP\)]

Column is a zero-based property, so the first column is actually .Column(0),
the second column is .Column(1), etc.

 

[Ken Snell \(MVP\)]

See this article at The ACCESS Web:
http://www.mvps.org/access/forms/frm0058.htm

It shows how to do what you seek when a combo box is used to select an ID.