Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   Forms (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=9)
-   -   Form Help? (https://www.access-programmers.co.uk/forums/showthread.php?t=306801)

SAMHERRELL 09-11-2019 12:45 PM

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!

theDBguy 09-11-2019 12:55 PM

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...


All times are GMT -8. The time now is 04:39 PM.

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