Prev: Multiple quotes for same job number using option buttons
Next: CBO List
From: Jeanette Cunningham on 4 May 2010 17:23
Look on the subform for the Before Insert event.
The subform is inside the subform control on the tab control.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"TheLee via AccessMonster.com" <u59624(a)uwe> wrote in message
news:a78269138ba14(a)uwe...
> Hi Jeanette -
> Thank you very much for the info. Unfortunately it looks like I cannot do
> this on the Tabbed Form. It does not have a Before Insert event. The main
> form does though.
>
> The issue is a user can fill out the subform prior to making an entry in
> the
> main form. Then when they go back and enter info in the main form it wipes
> out the info they entered in the subform. Maybe there is a way to force
> the
> main form to assign an OrderID when the user clicks on the tabbed form??
>
> Thanks -
> Lee
>
> Jeanette Cunningham wrote:
>>It should.
>>To use the code, you would open the subform in design view.
>>On the subform's property sheet, on the Events tab, find the event called
>>Before Insert
>>
>>On the same as that event, click the button with 3 dots on in (it's on the
>>right)
>>
>>Access will open the code window
>>
>>Copy and paste this code into the code window
>>
>>'start of code -------------
>>Option Compare Database
>>Option Explicit
>>
>>Private Sub Form_BeforeInsert(Cancel As Integer)
>> If Me.Parent.NewRecord Then
>> Cancel = True
>> MsgBox "Please enter the main form record first."
>> End If
>>End Sub
>>'end of code -------------------
>>
>>Notes:
>>Now check the very first lines of code at the top of the code window.
>>If you see
>>Option Compare Database
>>more than once, delete the copies until there is only one occurrence of
>>Option Compare Database
>>
>>Do the same for
>>Option Explicit
>>
>>Now on the menu at top of the screen, choose
>>Debug, then compile.
>>Save and close the code window.
>>Save and close the form.
>>Test the form to see how the code works.
>>
>>Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
>>
>>> Hi Jeanette,
>>> Will this also work if it is a tabbed subform? Sorry, I should have
>>[quoted text clipped - 32 lines]
>>>>> Thanks -
>>>>> Lee -
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201005/1
>


First  |  Prev  | 
Pages: 1 2
Prev: Multiple quotes for same job number using option buttons
Next: CBO List