Advertisement

09.11.2007 at 02:20PM PDT, ID: 22821814
[x]
Attachment Details

How - Filter by AutoNumber(Tracker ID) record with button & prompt on data entry form

Asked by Jumprope in Microsoft Access Database

Tags: autonumber, filter

The database will share deviation problems and solutions.  The five different engineers will each need to find there deviation record by assigned numbers.  They need to pull up the record in the data entry form and add root cause/corrective action message.  They will need to change the record status from Open to Submitted.  Finally the Department Mgr will find the Submitted records and accept or reject.
I have all built but the filter by record #.

How do I build a button (or box) that will filter by Tracker ID #?
How do I make the status change automatically when the Root Cause and Corrective action message if filled in?
Start Free Trial
[+][-]09.11.2007 at 02:30PM PDT, ID: 19872402

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: autonumber, filter
Sign Up Now!
Solution Provided By: RDWaibel
Participating Experts: 2
Solution Grade: A
 
 
[+][-]09.11.2007 at 03:11PM PDT, ID: 19872632

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]09.11.2007 at 03:13PM PDT, ID: 19872644

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628