Access World Forums

Access World Forums (
-   Forms (
-   -   Form Help? (

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