Eric the Viking
Registered User.
- Local time
- Today, 10:56
- Joined
- Sep 20, 2012
- Messages
- 70
Dear All, after quite some time away from this group I find myself in a state of confusion and in need of help after resuming my use of Access........I am treasurer of my angling club and have a data base to record items members have from the bar and other items including their subscription to send an end of season account. Members details are in a members table and their items for the end of season account are in a members debits table with the tables linked with a unique key.
I generally add items to the members debit table from a subform in my members table. All well and good and works just fine to produce the reports I need to email at the end of the season.
My problem is that with Covid-19 I have not been able to get to the club to extract the members debits from their account books. I would like to get the housekeeper to add these using a unique front end with just one form as I don't want her to be able to see all the members data and previous debit entries or have any chance of messing it up. My ideal solution would be to have a continuous form with members listed and then a button for each record to open a popup form prepopulated on load with the members name and number, plus empty text boxes for the new entry. Try as I might I just cannot get it to work......is there a way of doing it I have forgotten?
I also tried, as an alternative, a data entry form with a ComboBox at the top to search for the correct member but can't get this to work either.
Any suggestions gratefully received.
I generally add items to the members debit table from a subform in my members table. All well and good and works just fine to produce the reports I need to email at the end of the season.
My problem is that with Covid-19 I have not been able to get to the club to extract the members debits from their account books. I would like to get the housekeeper to add these using a unique front end with just one form as I don't want her to be able to see all the members data and previous debit entries or have any chance of messing it up. My ideal solution would be to have a continuous form with members listed and then a button for each record to open a popup form prepopulated on load with the members name and number, plus empty text boxes for the new entry. Try as I might I just cannot get it to work......is there a way of doing it I have forgotten?
I also tried, as an alternative, a data entry form with a ComboBox at the top to search for the correct member but can't get this to work either.
Any suggestions gratefully received.