Sally-
Consider adding a Form Header and put the combo there with Visible = False.
If the user clicks the Hold checkbox on, show the combo, and don't let them
save the record until they have chosen a reason. (Validate in Before Update
of the form.) In AfterUpdate, if Hold is True, then add a record to your
hold history table, clear the combo, and hide it.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Sally Vega
Sent: Tuesday, February 05, 2013 8:02 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Combo box in continous form, results on a separate
table
Hi All,
I try to find answers on this and other groups before posting a question but
this one has me stumped.
I have a filtered continuous form that is used to keep track of part
numbers and their status in the quotation process. Sometimes the status or
"gate" may be put on hold and I've been asked to track when and why.
I have checkbox for on hold/off hold working but I need to also have a combo
box with the reason code next to it on the main form. This part is working.
I have a separate table, the "Hold" table where I am keeping the part
number, gate and time it was put on or taken off hold. I was then asked to
add a combo box to track the reasons why they're put on hold. The question
is how do I get the results of the combo box to act independently on a
continuous form (unbound) and then how do I get the result of the combo box
to be input to the "Hold" table? Is this even possible to do?
I wanted to keep the "Hold" table separate as a log of the hold parts,
times, reasons, etc, because it would probably be easier to including these
in the aging reports.
Thank you,
Sally Vega, MBA
Supply Chain Data Analyst
Super First Class Products
B/E Aerospace, Inc.
1851 S. Pantano Rd.
Tucson, AZ 85710 USA
(520) 239-4812
This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you
are not the intended recipient, please contact the sender by reply e-mail
and destroy all copies of the original message.
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar