Newbie: adding to a subform

  • Thread starter Thread starter Bill Craig
  • Start date Start date
B

Bill Craig

Newbie, Access v2002

Hello,

I have a newbie quwstion that I need help with. I have
created a database using the "Service Call Management"
Template (it had almost everthing I needed), but I need
to make a change. I am using the Purchase Order field in
the Workorders table for my repair claim check number. I
use this number(s) to reference all repairs that I do.

What I need is inside of the subform that is in the
form "Workorders by Customer" to also list the Purchase
Order field from the Workorders table (my claim check
number(s)).

I seem to be having a hangup on this, and need help.

-Thanks in advance,
Bill Craig
(e-mail address removed)
 
Newbie, Access v2002

Hello,

I have a newbie quwstion that I need help with. I have
created a database using the "Service Call Management"
Template (it had almost everthing I needed), but I need
to make a change. I am using the Purchase Order field in
the Workorders table for my repair claim check number. I
use this number(s) to reference all repairs that I do.

What I need is inside of the subform that is in the
form "Workorders by Customer" to also list the Purchase
Order field from the Workorders table (my claim check
number(s)).
Click to expand...

Without knowing the struture of your tables (I haven't looked at this
template) I can't say for sure, but try using a textbox with a control
source of

=DLookUp("[PurchaseOrder]", "[Workorders]", <appropriate criteria>)

Since I don't know how the tables relate nor how you would identify
which is the right PO number, you'll need to fill in the <appropriate
criteria> yourself.
 
Back
Top