R
Ruth
I am working in an inherited Access2K database that tracks activity on
jobs.
Summary: I'm showing previous work done on a piece of equipment and
trying to append select records to a "Warranty Notes" table. Trouble
lies in getting the current work order number to show in the query and
write to the "Warranty Notes" table. Without the current Work Order
number in the record, I can't display on the "Warranty Notes" subform
tab.
Detailed info: The Jobs form has a tab where notes can be made to help
the manager determine if a repair falls within warranty. To aid in
gathering the information, I have created a button in the main form
that displays a continuous form with all previous work on this
equipment (keyed to [EUID], the unique identifier for the piece of
equipment.) Each line has a checkbox that can be checked if it
appears that work order might pertain to the current work being done.
At the bottom of the page, I have a text box (named [WOforHistory])
that captures the current WO# from Jobs form and displays it in the
footer (this works: =[Forms]![FrmJobEntry]![WOnumber]). I have written
a query that appends data from the previous WOs to a table
"WarrantyNotes." The criteria comes from the "AddtoNotes" checkbox.
The query displays the correct records but the field for WO displays
the letter "M" and a square symbol... or nothing at all. (I've tried
several different things and don't get a consistent result.) Here's
what the SQL looks like:
INSERT INTO tblWarrantyNotes ( WO, WarrNote )
SELECT [Forms]![FrmSearch2]![WOforHistory] AS WO, "Equip Loc where
repaired: " & [Location] & ", Job Desc: " & [JobDescription] & ", Date
Complete: " & [Stop] AS [Note]
FROM qrySearch2
WHERE (((qrySearch2.AddToHistory)=Yes));
As I said, the current work order number displays in the footer fine,
but the value is not passing to the query. I've also tried using the
value from the underlying Jobs form, but no luck there either. Any
other ideas on how I could pass this value into the query?
Thanks,
Ruth
jobs.
Summary: I'm showing previous work done on a piece of equipment and
trying to append select records to a "Warranty Notes" table. Trouble
lies in getting the current work order number to show in the query and
write to the "Warranty Notes" table. Without the current Work Order
number in the record, I can't display on the "Warranty Notes" subform
tab.
Detailed info: The Jobs form has a tab where notes can be made to help
the manager determine if a repair falls within warranty. To aid in
gathering the information, I have created a button in the main form
that displays a continuous form with all previous work on this
equipment (keyed to [EUID], the unique identifier for the piece of
equipment.) Each line has a checkbox that can be checked if it
appears that work order might pertain to the current work being done.
At the bottom of the page, I have a text box (named [WOforHistory])
that captures the current WO# from Jobs form and displays it in the
footer (this works: =[Forms]![FrmJobEntry]![WOnumber]). I have written
a query that appends data from the previous WOs to a table
"WarrantyNotes." The criteria comes from the "AddtoNotes" checkbox.
The query displays the correct records but the field for WO displays
the letter "M" and a square symbol... or nothing at all. (I've tried
several different things and don't get a consistent result.) Here's
what the SQL looks like:
INSERT INTO tblWarrantyNotes ( WO, WarrNote )
SELECT [Forms]![FrmSearch2]![WOforHistory] AS WO, "Equip Loc where
repaired: " & [Location] & ", Job Desc: " & [JobDescription] & ", Date
Complete: " & [Stop] AS [Note]
FROM qrySearch2
WHERE (((qrySearch2.AddToHistory)=Yes));
As I said, the current work order number displays in the footer fine,
but the value is not passing to the query. I've also tried using the
value from the underlying Jobs form, but no luck there either. Any
other ideas on how I could pass this value into the query?
Thanks,
Ruth