Hi Folks,
After some research on this site, I was able to solve half of my problems with my current database project. However, like often time, I fixed one thing only to create a new issue. Here's what I'm trying to do:
I have a main form that controls 2 subforms. sbfActiveProjects displays a list of records that have not been flagged as complete. Upon clicking on a record in sbfActiveProjects, the details of that record show up in sbfProject. This functionality works great, except when I try to create a new record. The code works fine for getting a new record, however once I run the command I lose my ability to navigate to other active records. Any suggestions?
Creating a New Record Within a Subform
After some research on this site, I was able to solve half of my problems with my current database project. However, like often time, I fixed one thing only to create a new issue. Here's what I'm trying to do:
I have a main form that controls 2 subforms. sbfActiveProjects displays a list of records that have not been flagged as complete. Upon clicking on a record in sbfActiveProjects, the details of that record show up in sbfProject. This functionality works great, except when I try to create a new record. The code works fine for getting a new record, however once I run the command I lose my ability to navigate to other active records. Any suggestions?
Code:
Private Sub cmdNewProject_Click()
'set focus to sbfProject
sbfProject.SetFocus
'navigate to new record
DoCmd.GoToRecord , "", acNewRec
End Sub
0 commentaires:
Enregistrer un commentaire