mrFlibble47
New member
- Local time
- Today, 01:47
- Joined
- Apr 30, 2008
- Messages
- 4
Hello,
I have had a search through the forums before posting this and have found previous threads that touch on this area but not (yet) managed to find one that covers everything i need to know.
I have a main form with a subform - in the subform it shows records from the "Scores" table (in continuous form view) and next to each i have a command button that opens the "L&D" form showing records from the "L&D" table filtered to show those that correspond to that score.
That uses this code i found here - so far so good.
The problem is getting the form to autopopulate various fields when you create a new record - at the moment if you create a new record all the fields are blank so anything created will not subsequently show up if you close and re-open the L&D form.
The Scores form has the fields ScoreID and EmployeeID which would need to be used to populate the fields of the same name in the L&D form when a new record is created in the (filtered) L&D form.
I hope someone can help me with this (and that i haven't been too incoherent in my explanation )
I have had a search through the forums before posting this and have found previous threads that touch on this area but not (yet) managed to find one that covers everything i need to know.
I have a main form with a subform - in the subform it shows records from the "Scores" table (in continuous form view) and next to each i have a command button that opens the "L&D" form showing records from the "L&D" table filtered to show those that correspond to that score.
That uses this code i found here - so far so good.
Code:
stDocName = "L&D"
stLinkCriteria = "[ScoreID]=" & Me![ScoreID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
The problem is getting the form to autopopulate various fields when you create a new record - at the moment if you create a new record all the fields are blank so anything created will not subsequently show up if you close and re-open the L&D form.
The Scores form has the fields ScoreID and EmployeeID which would need to be used to populate the fields of the same name in the L&D form when a new record is created in the (filtered) L&D form.
I hope someone can help me with this (and that i haven't been too incoherent in my explanation )