I've searched the forums - apologies if this has already been answered.
I have a main form (patients) with a subform (employment details). On the subform, I have various controls for employment details. One of these is for Job title. This is currently another subform (disguised as a combo box), which will search for job titles drawing from another form. It has code (on Not In List) so that if a job title isn't listed, the user can add it to a form without leaving the main form.
I have the sub-subform (combo box) embedded nicely in the subform so it looks like a regular combo box. I have set up the tab order so that I can work through the Employment subform (date started, finished, job description etc). I can tab into the subform, but am not able to tab out of it, as it is a subform, and keeps adding new records when I hit tab.
Each employment record only needs one job title (drawn from the combo box), but I can add multiple jobs for each patient with the employment subform if necessary.
Am I able to set it up so that I can tab out of the combo box (sub-subform) so that it won't keep trying to go to another record? I have tried adding code GoToControl, On Enter, On Update etc, but my programming knowledge is very poor so nothing worked!
Any suggestions???
PS thanks in advance for any help offered!!!
I have a main form (patients) with a subform (employment details). On the subform, I have various controls for employment details. One of these is for Job title. This is currently another subform (disguised as a combo box), which will search for job titles drawing from another form. It has code (on Not In List) so that if a job title isn't listed, the user can add it to a form without leaving the main form.
I have the sub-subform (combo box) embedded nicely in the subform so it looks like a regular combo box. I have set up the tab order so that I can work through the Employment subform (date started, finished, job description etc). I can tab into the subform, but am not able to tab out of it, as it is a subform, and keeps adding new records when I hit tab.
Each employment record only needs one job title (drawn from the combo box), but I can add multiple jobs for each patient with the employment subform if necessary.
Am I able to set it up so that I can tab out of the combo box (sub-subform) so that it won't keep trying to go to another record? I have tried adding code GoToControl, On Enter, On Update etc, but my programming knowledge is very poor so nothing worked!
Any suggestions???
PS thanks in advance for any help offered!!!