Re: How to I tab from sub form to main form?

Thanks,

You were right.

On Sat, 11 Jun 2005 11:26:02 -0700, "Ofer"
<Ofer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>You probably put the code in the line of the property, instead in that
>property you can choose three options one of them is code, select the code
>and enter it as VBA.
>When you put something in the line of the property the application look for
>a macro.
>
>
>"Robin Chapple" wrote:
>
>> Thanks,
>>
>> I understand the logic but I have done something wrong.
>>
>> Here is your code with my form name and field name:
>>
>> Forms![frmMembers].[Notes].setfocus
>>
>> I get an error message:
>>
>> ""Can't find macro "Forms!frommembers"
>>
>> What did I miss?
>>
>> Thanks again
>>
>> On Fri, 10 Jun 2005 01:29:04 -0700, "Ofer"
>> <Ofer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>>
>> >From the last field in the subform, set a focus to the reuired field in the
>> >main form.
>> >e.g
>> >In the "lost focus" property of the last field on the subform, put the code
>> >Forms![MainFormName].[FieldNameToGetFocus].setfocus.
>> >
>> >"Robin Chapple" wrote:
>> >
>> >> I have a main form with member details and a sub form with history.
>> >>
>> >> I have made th tab order so that tab stops 20 and 21 are on a sub
>> >> form, (actually 1 and 2 on that form).
>> >>
>> >> How do I make the next tab stop the next fields on the main form?
>> >>
>> >> Thanks,
>> >>
>> >> Robin Chapple
>> >>
>>
>>

.

Relevant Pages

  • RE: "Runtime Error 2110" cannot move the focus to the control
    ... I have the subform is set correctly but I am trying to set.focus to the main ... >> I have a combobox that I have set.focus to but get the error message above, ... >> but it updates prior to the error. ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Subform data input problem
    ... be able to input dates in multiple records of this subform and be saved for ... I can input the 2nd record of the subform but I get an error ... one I get an error message “The changes were not successful because they ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Problems with background image
    ... Im trying to get the background of a subform the same as the form its placed ... but this one seems to throw up the following error message ... im linking it to the following ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: How to suppress the "no current record" error.
    ... is about your form and subform that makes this error message popup. ... forms are setup that will stop that silly error message from popping up. ... Starting with a new form subform setup where that silly message does not ... viewing a permit which has a recordset for audits, ...
    (microsoft.public.access.formscoding)
  • RE: Error 2455 (associated with subform reference)
    ... The form is a purchase order form, and the subform ... lock some of the controls by looping through them. ... I have checked references, compacted the database, decomplied with a command ... could probably pass over the error message in the code's error handling, ...
    (microsoft.public.access.formscoding)