I'm fairly new to Access and this is my 1st foray into subforms. Here is what I have.
Main Form: frmOrders
SubForms of frmOrders: frmGuide and frmBotBar
When I get to the my last field of the main form, frmOrders, because of tab control the cursor moves to the form, frmGuide. That is what I want it to do. When I reach the last field of frmGuide, if I press the tab key, another record is created within frmGuide. I do not want that, as there is a 1-1 relationship between the tables behind frmOrders and frmGuide.
I set Allow Additions = NO in the form frmGuide. I was hoping that it would not allow additional records, but it does what it says and allows no records at all.
I changed that back and then I put the following code into the OnExit event of my last field, HPAreaJambSlotSize, of the form, frmGuide, hoping that it would send focus to frmBotBar. It doesn't send focus to frmBotBar, but it doesn't create a new record either. I can then use the mouse to click on frmBotBar or frmOrders to get to those forms, but if I try to go back to frmGuide, I can't leave the field that I was previously in. So, that isn't a good solution either.
Private Sub ComboHPAreaJambSlotSize_Exit(Cancel As Integer)
' Test to make sure field has a value if necessary
If GuideConfig = "B" Then
If IsNull(HPAreaJambSlotSize) Then
MsgBox "HP Area Jamb Slot Size must be have a value when a Guide Configuation = B." ComboHPAreaJambSlotSize.SetFocus
Cancel = True
' Send focus to frmBotBar
If BelowHPJambSlotSpace.Enabled = True Then
Cancel = True
I replaced this line
with this line
and it now moves to frmBotBar. I can move to frmOrders, but when I move back to frmGuide, it always goes to BelowHPJambSlotSpace.
What is the proper way to change the focus back to frmOrders or to frmBotBar?
Edited by: PA232 on Tue Mar 18 16:11:58 EDT 2008.