Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-11-2019, 12:45 PM   #1
SAMHERRELL
Newly Registered User
 
Join Date: Sep 2019
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
SAMHERRELL is on a distinguished road
Form Help?

Hi new friends! I am very new to access. I am attempting to make a documentation tool to track member activities.

After searching for member, I bring up a member profile.

Here is what I can't figure out.
I want to free type information about that member and save and close it.

But I want it to them be transferred to a list box to I can retrieve and review later. I will have multiple notes on each member. and for encounter I have it want it to show separate below.

Can someone point me in the right direction? I was thinking a bound text box and a list box embeded in a tab as a subform to my form?? I have my main member profile table.

Access is hard. You guys (and gals) are amazing and I look up to each one of yall!

SAMHERRELL is offline   Reply With Quote
Old 09-11-2019, 12:55 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,146
Thanks: 46
Thanked 971 Times in 952 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Form Help?

Hi. Welcome to AWF! What you're describing seems to be a one-to-many relationship between the member's profile record and your notes. If so, I would suggest storing the notes in a separate table and use a subform to enter then in the member's profile form. Hope it helps...
__________________
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 offline   Reply With Quote
Reply

Tags
forms on tabs

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




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