Very Newbie: Adding field to subform

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

Bill Craig

I know that this a simple question for most, but it one
that I am tripping on, and I need the answer in simplest form.

I have created a new database using the "Service Call
Management" template. The database has almost everything I
need in it except for a spot to enter Repair Claim Numbers.

So, I am using the PO Number field in the Workorders table
to enter the claim number (I do not need PO Numbers). With
all of that laid out, here is my problem...

There is a form (Workorders by Customer) that has a subform
(Workorders by Customer Subform). The subform has most of
the quick reference information that I need except for the
"PO Number" field that is in the workorders table.

So, how do I get the PO Number field to show up in the
subform? Please reply as if you are talking to someone who
knows nothing about how to build expressions (because I
don't). The last purson that tried to help me from the
"Forms Programming" newsgroup talked above my knowledge of
Access.

Thanks,
Bill Craig
(e-mail address removed)
 
There is a form (Workorders by Customer) that has a subform
(Workorders by Customer Subform). The subform has most of
the quick reference information that I need except for the
"PO Number" field that is in the workorders table.

So, how do I get the PO Number field to show up in the
subform? Please reply as if you are talking to someone who
knows nothing about how to build expressions (because I
don't). The last purson that tried to help me from the
"Forms Programming" newsgroup talked above my knowledge of
Access.
Click to expand...

Sorry! That was me, I think.

I need a bit more information to give a clear answer, I think.

- What is the Recordsource of the [Workorders by Customer] form? Open
the Form in design view; view its Properties (right mouseclick the
little square at the upper left intersection of the rulers and select
Properties). Find the Recordsource property; click the ... icon to
open a query grid. Select View... SQL and copy and paste the SQL text
to a message here.

- Do the same for the Subform.

- Also post the Master Link Field and Child Link Field properties of
the subform.

- If it's not obvious from the SQL, tell me where the PO number is to
be found and how you can determine WHICH PO number should be displayed
on the subform.
 
Hello Bill
John is a good MVP he helped me with my problem.
I am no MVP but I think I know what your looking for.

Like John said open the subform (Workorders by Customer Subform)
in design view you will see a small square box top left of the form
DblClick on it that will open the Forms properties.
Under the all tab or Data tab you will see the Record Source
it will look something like this:

SELECT DISTINCTROW [Workorders].[WorkorderID], [Workorders "exc.exc.exc"
now if you have not changed any names in the table as it was created by the
wizard
Add this to the front of that statement

[Workorders].[PurchaseOrderNumber],

so it looks like:

SELECT DISTINCTROW [Workorders].[PurchaseOrderNumber],
[Workorders].[WorkorderID], [Workorders "exc.exc.exc"

Now close the Forms properties and add the textBox to the form

In design view you will see the
Workorders by Customer Subform : Form
grab the lower right corner and open it so you can see all the (Detail
section) of the form

On you toolbar you will see the (AB|) that is the textBox tool click on it
and then click on the form in the Detail section that will add the textBox

the textBox will say unbound right click on it open the textBox properties
Under the Data tab or the allTab you will see Control Source click on the
arrow to the right
and select (PurchaseOrderNumber) and close the textBox properties.

Now the textBox should read PurchaseOrderNumber

On the label to the right click once wait click again and type Repair Claim
Numbers.

Ok the form is a DataSheet so to make this be the second Item on the list
right click on the little sq again and select tab order
click PurchaseOrderNumber once and then left click on it and hold
drag it up to the second spot

That it close the form and test

Notes:
I am using Access 97
Be real careful with that SQL statement a lot going on there

Good Luck
Thomas





John Vinson said:
There is a form (Workorders by Customer) that has a subform
(Workorders by Customer Subform). The subform has most of
the quick reference information that I need except for the
"PO Number" field that is in the workorders table.

So, how do I get the PO Number field to show up in the
subform? Please reply as if you are talking to someone who
knows nothing about how to build expressions (because I
don't). The last purson that tried to help me from the
"Forms Programming" newsgroup talked above my knowledge of
Access.
Click to expand...

Sorry! That was me, I think.

I need a bit more information to give a clear answer, I think.

- What is the Recordsource of the [Workorders by Customer] form? Open
the Form in design view; view its Properties (right mouseclick the
little square at the upper left intersection of the rulers and select
Properties). Find the Recordsource property; click the ... icon to
open a query grid. Select View... SQL and copy and paste the SQL text
to a message here.

- Do the same for the Subform.

- Also post the Master Link Field and Child Link Field properties of
the subform.

- If it's not obvious from the SQL, tell me where the PO number is to
be found and how you can determine WHICH PO number should be displayed
on the subform.
Click to expand...
 
Back
Top