J
Jere Shaw
Help! Anyone!
I created a database application using Access that that produces invoices
for a small company. The application has three tables, Job, Job Details, and
Parts. The Parts table contains data downloaded from the Internet from a
supplier of parts and is used as a lookup table to supply information for
the Job Detail table.
Data is entered into the Job table through a form called Job. The Job form
also has a sub form called Job Details sub form for entering data for the
Job Details table. It is opened as a datasheet.
The sub form has a combo box entitled SKU. Its control source is sku, a
field in the Job Details table. The purpose of the combo box is to load a
number from the Parts table. Also, attached to the After Update property of
the combo box, is a macro that is supposed to set values from the Parts
table for the Description and Unit Price into the Parts Detail table.
My problem: When I access the data though the job form and click on the
combo box, a list from the Parts table appears. When I select a sku number
from the list, it loads into the form. However, the Marco then halts not
allowing the description and price values to be set. If I run the sub form
by itself (not in the Job Form), It works perfectly.
Does anyone have any ideas why it works as an independent form but not when
I access it through the Job form, and how can I correct the problem?
Any help is appreciated.
I created a database application using Access that that produces invoices
for a small company. The application has three tables, Job, Job Details, and
Parts. The Parts table contains data downloaded from the Internet from a
supplier of parts and is used as a lookup table to supply information for
the Job Detail table.
Data is entered into the Job table through a form called Job. The Job form
also has a sub form called Job Details sub form for entering data for the
Job Details table. It is opened as a datasheet.
The sub form has a combo box entitled SKU. Its control source is sku, a
field in the Job Details table. The purpose of the combo box is to load a
number from the Parts table. Also, attached to the After Update property of
the combo box, is a macro that is supposed to set values from the Parts
table for the Description and Unit Price into the Parts Detail table.
My problem: When I access the data though the job form and click on the
combo box, a list from the Parts table appears. When I select a sku number
from the list, it loads into the form. However, the Marco then halts not
allowing the description and price values to be set. If I run the sub form
by itself (not in the Job Form), It works perfectly.
Does anyone have any ideas why it works as an independent form but not when
I access it through the Job form, and how can I correct the problem?
Any help is appreciated.