1 form or use Subforms?

#1 February 28th, 2005, 02:25 AM

I am building a DB, using Access 2003, that tracks projects and thus the form
has a Project Name and then requires a location to enter the several
contractors who work on this project. It is my intent to draw the contractor
names from my outlook contact list through the use of a drop down type of
list box. Does anyone have any design suggestions of how this can be
accomplished.

#2 February 28th, 2005, 04:50 AM

savv32 wrote:
I am building a DB, using Access 2003, that tracks projects and thus
the form has a Project Name and then requires a location to enter the
several contractors who work on this project. It is my intent to draw
the contractor names from my outlook contact list through the use of
a drop down type of list box. Does anyone have any design suggestions
of how this can be accomplished.

"Several" almost always means a subform.
You may end up with two or a listbox and subform if a contractor may have to
or more jobs to do.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dates in a listbox connected to a form...	RusCat	Using Forms	13	November 25th, 2004 02:31 AM
Need query to separate 2 entry types in a table field	Jan Il	Running & Setting Up Queries	31	November 23rd, 2004 05:57 PM
Cursor Positioning	Colin Hammond	General Discussion	3	November 2nd, 2004 08:42 PM
Copy form with subforms, change copy without changing original fo	DJWF	Using Forms	1	October 24th, 2004 01:18 AM
auto entry into second table after update	Tony	New Users	13	July 9th, 2004 10:42 PM