Kommando Knap Skal sende markør til felt i underformular

Me.SubFormConatainer.[T-BiID].Setfocus

SubFormConatainer = SubFormContainer which is the name of the object containing the sub form

http://www.mvps.org/access/forms/frm0031.htm

Det kan jeg ikke få til at virke.

Er det ikke noget med at der skal være nogle '!' indblandet?

Jeg har prøvet det du skriver, men den skriver bare at :

Run-Time error '438':

Object Doesn't support this property or method



Det stykke kode jeg har i øjeblikket er:

    Me.frmTransportSub.[T-BilID].SetFocus


Kan ikke helt forstå den side du har givet mig et link på. er ikke så god til at forstå hvad de mener når det står skrevet på engelsk derinde.

Min underformular hedder frmTransportSub, og den det hedder den også som ObjectName i hovedformularen.

normally I use . but in some cases it sbest to use!

Try
Me!SubFormContainer.form.[T-BilID].SetFocus

NOTE: SubFormContainer is the object containing the sub form. Normally they will have the same name, but this is NOT necessary. So make sure that you replace

SubFormContainer with the name of the object containg the sub form and NOT the name of the sub form.

If you still have problems then your welcome to send me your dB and I'll see if I can find the problem.

eksperten@NOSPAMsanthell.dk

remove NOSPAM

Det virkede heller ikke. har tjekket alt det du sagde, og nu har jeg så sendt den til din e-mail.

Knud, try compiling your database. There are a number of errors which you should correct.
Then use:

Me.frmTransportSub.Form.[T-BilID].SetFocus
Me.frmTransportSub.SetFocus

Hej Terry..
ja, nu virker det. Kan dog ikke forstå at du siger jeg skal komprimere min dB, fordi det gjorde jeg nemlig lige før jeg sendte den til dig.

Kan du forklare mig hvorfor det er nødvendigt med begge linjer og kun den første?

Hi Knud

I dont mean compact but compile. (Debug+Compile menu i code view).

The first line of code actually does place the cursor in the correct field. But focus is still on the main form. So its necessary to move focus to the sub form.

Try only using the first line, and then click on the scroll bar in the sub form. You will now see that the cursor is in the correct field. By clicking on the scroll bar you move focus to the sub form.

You could say that each form will have focus on a field, but the form has to have focus before you can actually see it.

If you move focus back to the main form you will see that the field which had focus before moving to the sub form will again have focus.

and that was an answer :o)