Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-08-2016, 01:42 PM   #1
rlmoss44
Newly Registered User
 
Join Date: Apr 2016
Posts: 3
Thanks: 2
Thanked 0 Times in 0 Posts
rlmoss44 is on a distinguished road
Searching for a record from multiple forms

I am learning through trial and error about creating a database and now I'm stuck. I currently have 4 tables and 4 forms(which will grow). The forms are set up to pull data from the applicable table. Each table has numerous fields (no duplicates). I've also created a Form called "Main Menu" that list buttons that will "GotoForm"

Im trying to create a search box or button on the Main Menu Form that when I enter a SSAN it takes me to the record on form that person belongs to. Is this possible using a code?? For instance GoTo Record?

rlmoss44 is offline   Reply With Quote
Old 04-08-2016, 02:52 PM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,072
Thanks: 10
Thanked 3,871 Times in 3,814 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Searching for a record from multiple forms

What do the tables contain? From your statement "form that person belongs to", it sounds like you have tables for each person or something. That would almost certainly be a mistake.
__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
rlmoss44 (04-11-2016)
Old 04-08-2016, 03:31 PM   #3
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 11,573
Thanks: 57
Thanked 1,875 Times in 1,825 Posts
jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice
Re: Searching for a record from multiple forms

rlmoss44,
Learning by trial and error is a long and unpleasant process.
Here is a great Access Basics guide from Crystal

You should also become familiar with relational database concepts. Here are some freevideos to help.

Good luck.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
The Following User Says Thank You to jdraw For This Useful Post:
rlmoss44 (04-11-2016)
Old 04-11-2016, 08:56 AM   #4
rlmoss44
Newly Registered User
 
Join Date: Apr 2016
Posts: 3
Thanks: 2
Thanked 0 Times in 0 Posts
rlmoss44 is on a distinguished road
Re: Searching for a record from multiple forms

the tables have anywhere from 100 to 300 record lines but each table has a "SSAN" field....In all of my forms I made a search box the finds the record based on the SSAN but its only looks at one table. The link is a screenshot of my current tables. You can see that all of them have a SSAN field. I tried the relationship but couldn't figure it out. Thanks in advance

To see the link delete the space after //

https:// drive.google.com/file/d/0Bw6XwWjMZP5iWHhsa3pGUDYtVmc/view?usp=sharing
rlmoss44 is offline   Reply With Quote
Old 04-19-2016, 08:58 AM   #5
rlmoss44
Newly Registered User
 
Join Date: Apr 2016
Posts: 3
Thanks: 2
Thanked 0 Times in 0 Posts
rlmoss44 is on a distinguished road
Re: Searching for a record from multiple forms

I fixed it!! what I did was just put all the information on an excel sheet and created a 1 table that I had to drastically modify, thanks again for all your help!!
rlmoss44 is offline   Reply With Quote
Old 04-19-2016, 09:28 AM   #6
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,072
Thanks: 10
Thanked 3,871 Times in 3,814 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Searching for a record from multiple forms

Glad you have a solution that works for you.

__________________
Paul
Microsoft Access MVP

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

Tags
button , multiple forms , search

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Forms - multiple record vince1818 Forms 24 04-29-2015 02:37 PM
Searching for record using multiple criteria Cirrostratus Modules & VBA 29 08-07-2013 08:03 AM
maintain the same record across multiple sub forms tadd Forms 14 07-10-2009 12:48 PM
Searching for record by multiple fields carlisle Forms 1 09-09-2006 05:45 PM
Searching Multiple Forms Graybeard Forms 3 09-13-2004 05:36 PM




All times are GMT -8. The time now is 10:58 PM.


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

Sponsored Links

How to advertise

Media Kit


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