Keeping autofill simple

[Ray McKinney]

Yes I know this will cause a few eye rolls and I sincerleyl apologize but you guys did come up TOPS on google search for ACCESS help so this is the price of being famous.

I have multiple tables, so I'll start with just two. The first has

WO (work order number)
Sched Start Time
Sched Start Date
and a ton of other data specific to the work order.

Table 2 is for tracking work delays.
On the form, I want a drop down (from table 1) with all of the work orders available. When the user selects the work order (or better yet simply types in a valid work order number) I would like the Sched Start time, Sched start date to automatically load into table 2. Table 2 will be used to track multiple delays so the same work order will be loaded multiple times. I could track the delays in table 1 but that will make for a lengthy record and I will not be able to print out specific delays. By tracking in table 2, each delay will be assigned an autonumber specific to that delay.

So, do I link the table in a query? Do I build the form from a table or a query? Start from scratch here. We are using Office 2003 at this plant site. Thanks for your patience.

 

[Galaxiom]

Set Row Source Type of the combo box to Table/Query

Set the Row Source property as:
SELECT [Table 1].WO FROM [Table 1] ORDER BY [Table 1].WO;

Set the Limit To List property to Yes

As I pointed out in your related question, don't repeat the data in table 2.
http://www.access-programmers.co.uk/forums/showthread.php?t=176785

 

[Ray McKinney]

Thanks for the help. I knew I came to the right place.