J
J. Trucking
Hello,
I just have a quick question. I have a form that is linked to a table
which stores a bunch of information about different pieces of
machinery (1 record for each machine). On this form, I have a subform
which holds information regarding a parts list for each piece of
machinery. I have the parts list as a subform because the parts for
each machine will be different (ie) the parts for a dump truck will be
different from that of a bulldozer. However, there will be some part
items that will overlap such as oil filters, fuel filters, air filters
etc.
My question is: is there a way to default in 3 or 4 records on each
subform, but just on one field. In my subform, I have the fields
PartID, PartName, Supplier, PartNumber, Notes, and FleetID. FleetID
is the field that links my form with my subform. What I would like to
be able to do, is when a new piece of machinery is created on the
form, the subform already has OIL FILER, AIR FILTER, FUEL FILTER, etc.
already listed in the PartName field while leaving Supplier,
PartNumber, and Notes blank. So, for example, if I added a machine
called "service truck", I could look at the subform and see "OIL
FILTER, AIR FILTER, and FUEL FILTER" in the PartName column, and all I
would have to do is add the PatNumber, the Supplier, and any Notes I
wanted. My subform is on Datasheet View.
Just wondering if this is possible. I need to keep the subform this
way (expandable) because the different types of machinery will warrant
slightly different parts lists (also in case I forget to add a part, a
user can come in and add it).
Thanks in advance for any help.
John
I just have a quick question. I have a form that is linked to a table
which stores a bunch of information about different pieces of
machinery (1 record for each machine). On this form, I have a subform
which holds information regarding a parts list for each piece of
machinery. I have the parts list as a subform because the parts for
each machine will be different (ie) the parts for a dump truck will be
different from that of a bulldozer. However, there will be some part
items that will overlap such as oil filters, fuel filters, air filters
etc.
My question is: is there a way to default in 3 or 4 records on each
subform, but just on one field. In my subform, I have the fields
PartID, PartName, Supplier, PartNumber, Notes, and FleetID. FleetID
is the field that links my form with my subform. What I would like to
be able to do, is when a new piece of machinery is created on the
form, the subform already has OIL FILER, AIR FILTER, FUEL FILTER, etc.
already listed in the PartName field while leaving Supplier,
PartNumber, and Notes blank. So, for example, if I added a machine
called "service truck", I could look at the subform and see "OIL
FILTER, AIR FILTER, and FUEL FILTER" in the PartName column, and all I
would have to do is add the PatNumber, the Supplier, and any Notes I
wanted. My subform is on Datasheet View.
Just wondering if this is possible. I need to keep the subform this
way (expandable) because the different types of machinery will warrant
slightly different parts lists (also in case I forget to add a part, a
user can come in and add it).
Thanks in advance for any help.
John