Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-06-2013, 10:25 AM   #1
MarkRyan
Newly Registered User
 
Join Date: Aug 2013
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
MarkRyan is on a distinguished road
Filtering a split form

I have a database and form that is used to register times and various codes for employees to enter their work schedule for the day. Right now I am using a split form where they enter a ID code in the form and it auto populates with their name/department/and date. They then go and fill out a few boxes regarding time spent, machine used, and purchase order.

Once the information is added it is seen below due to it being a split form.

My question is this:
Can I make the bottom portion (split form) filter and display only that specific employees ID number and his previous entries? Right now it is possible to view all of the entries placed and due to it being used on a network connection there are many submissions, I want it to narrow down so that once the employee enters his/her own ID only their previous submissions for that day can be viewed.

Thanks.

MarkRyan is offline   Reply With Quote
Old 08-08-2013, 04:02 PM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,334
Thanks: 40
Thanked 3,670 Times in 3,538 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Filtering a split form

If you are using the access defined split form, I believe the answer is no since the datasheet at the bottom is just a way of selecting a record to display in the main form.

I don't use them myself, but you could try using the split form as a subform to another 'main' form and have to employee details entered on the new main form and set the link child and master properties to filter the split form
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Reply

Tags
form , split , view

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Filtering split form records from combo box mcdhappy80 Forms 10 05-10-2017 06:33 AM
Filtering in a Split Form Roger Reinsch Forms 1 09-02-2012 07:09 PM
Search filtering on a split form? JAy3k1 Queries 0 04-03-2011 12:08 PM
Form Split Data Sheet filtering - 2007 sumdumgai Forms 2 08-24-2010 10:29 AM
Filtering split form with search box & combo boxes nelo Forms 10 07-15-2010 12:32 PM




All times are GMT -8. The time now is 12:47 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World