Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-01-2019, 04:58 AM   #1
littlecool
Newly Registered User
 
Join Date: Mar 2014
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
littlecool is on a distinguished road
Sorting records on a form with another form

Hello,
I'm looking to make a form that will allow me to sort records in another form. I want to be able to limit the records viewed by a date range that the user can choose, as well as by area and team (fields on the main form), hit a "go" button, and the main form to open up with the user selected criteria active. How can I achieve this?

Thank you,

LC

littlecool is offline   Reply With Quote
Old 12-01-2019, 05:05 AM   #2
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,252
Thanks: 115
Thanked 3,075 Times in 2,793 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Sorting records on a form with another form

The easiest way is to use a subform to display the results with textboxes and/or combos in the main form to make the selections for filtering/sorting the data.
See the two example apps in this thread https://www.access-programmers.co.uk...d.php?t=302189
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 12-01-2019, 05:20 AM   #3
littlecool
Newly Registered User
 
Join Date: Mar 2014
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
littlecool is on a distinguished road
Re: Sorting records on a form with another form

Unfortunately a sub form won't work due to the amount of information the main form provides. I don't mind coding, I'm just not sure what that would look like.

littlecool is offline   Reply With Quote
Old 12-01-2019, 05:38 AM   #4
bob fitz
AWF VIP
 
Join Date: May 2011
Location: Essex England
Posts: 3,534
Thanks: 52
Thanked 684 Times in 666 Posts
bob fitz has a spectacular aura about bob fitz has a spectacular aura about bob fitz has a spectacular aura about
Re: Sorting records on a form with another form

Quote:
Originally Posted by littlecool View Post
Unfortunately a sub form won't work due to the amount of information the main form provides. I don't mind coding, I'm just not sure what that would look like.
1) How is your "Main" form displayed (Single Form, Datasheet or Continuous)?
2) Please explain why the amount of information on the main form prevent it from being shown as a subform on a form used to get the criteria?
__________________
Bob Fitzpatrick
Microsoft Community Contributor Award (2011)
If this helped, please click the scales at the bottom left of this posting.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Many thanks.


I have never failed. I have found a thousand ways that do not work!
bob fitz is offline   Reply With Quote
Old 12-01-2019, 05:49 AM   #5
vba_php
Software Engineer
 
vba_php's Avatar
 
Join Date: Oct 2019
Location: Iowa City, IA
Posts: 562
Thanks: 69
Thanked 60 Times in 60 Posts
vba_php is on a distinguished road
Re: Sorting records on a form with another form

little,

ur question was asked just a couple days ago. I provided the following example to the other guy. this is done with query input parameters, but it doesn't take much code to change it to what you want...
Attached Files
File Type: accdb example criteria pop up form.accdb (608.0 KB, 3 views)
__________________
-Adam
vba_php is offline   Reply With Quote
Old 12-01-2019, 06:42 AM   #6
littlecool
Newly Registered User
 
Join Date: Mar 2014
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
littlecool is on a distinguished road
Re: Sorting records on a form with another form

Bob, my form is in Single form. My main form is a logbook for maintenance items, which includes a subform already. There's no more room on the screen for it, and I don't want to enable scrolling to have to scroll.
littlecool is offline   Reply With Quote
Old 12-01-2019, 07:14 AM   #7
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,888
Thanks: 38
Thanked 571 Times in 538 Posts
MajP has a spectacular aura about MajP has a spectacular aura about
Re: Sorting records on a form with another form

This is my basic go to for filter and sort design. Two versions. One is the filter and sort controls on the form, the other uses a pop up.
Attached Files
File Type: accdb MajP SimpleSearch.accdb (748.0 KB, 4 views)

MajP is offline   Reply With Quote
The Following User Says Thank You to MajP For This Useful Post:
littlecool (12-01-2019)
Old 12-01-2019, 08:02 AM   #8
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,888
Thanks: 38
Thanked 571 Times in 538 Posts
MajP has a spectacular aura about MajP has a spectacular aura about
Re: Sorting records on a form with another form

Here is a minor update to show a simple way to get a Sort from the popup as well
Attached Files
File Type: accdb MajP SimpleSearch V2.accdb (756.0 KB, 4 views)
MajP is offline   Reply With Quote
The Following User Says Thank You to MajP For This Useful Post:
littlecool (12-01-2019)
Old 12-01-2019, 08:31 AM   #9
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,486
Thanks: 58
Thanked 1,419 Times in 1,400 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Sorting records on a form with another form

Hi. Lots of demo here to try out, if you're so inclined. Cheers!

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re-sorting form's records ellenr Modules & VBA 3 09-22-2016 06:24 PM
Problems with sorting records on a form hammerva General 6 11-25-2003 01:20 PM
sorting records in a form octatyan Forms 3 06-19-2003 10:20 AM
Sorting records on a form Courtman Forms 3 11-07-2002 03:05 AM
Sorting records in a form Karyn Forms 1 08-30-2000 11:07 PM




All times are GMT -8. The time now is 05:32 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