Re: Sub Form Problems

Tech-Archive recommends: Fix windows errors by optimizing your registry

It shouldn't make a difference. The reference should remain the same whether
it is on a tab or not. You do not reference the tab control in any way in
this case. How are you referencing it?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


"Winger" <Winger@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1E32BB6E-A3CF-44CB-8D48-490A4BC9BDB9@xxxxxxxxxxxxxxxx
Roger,

I've moved the subform onto a tab control to get more room, and now it
dosn't work again!! How do I reference it through a tab control??

Many thanks



"Roger Carlson" wrote:

You have to reference the form THROUGH the main form. In general, it
looks
like this:

forms!mainform!subformControl.Form!Control

or in your case:
Forms!MainForm![View Personal Details].Form![Last Name]

Now, this assumes that the subform and the subform *control* (that is
the
control object on the main form that holds the subform) are both named
"View
Personal Details".

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformReference.mdb" which illustrates a number of
issues
with referencing subforms and subsubforms.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L




"Winger" <Winger@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AF7EDFB4-B296-4A68-B3D1-C17495537F48@xxxxxxxxxxxxxxxx
I've tried to read through and follow previous threads on related
issues,
but
unfortunalty still can't my prob resolved. I suspect I am missing
something
basic.

1) I have a form, with an event "on Click" that opens another form and
selects the relavent data from the first firm, using the condition
[Personal Details]![Last Name]=[Forms]![View Personal Details]![Last
Name]

However when this form becomes a sub-form it then dosn't work.
What changes do I need to make? and where?

2) I have another form, with sub-form but keep getting the message
"The
LinkMasterFields property setting has produced this error:......"

The Main form has a Primary Key on "Event Ref" and has a One-to-many
relationship with the "Attendees" Sub form. Attendeeds has two Primary
Keys
on Event Ref: and Email address.

The Link Child / Master propertys seem to be set to link between
"Event
Ref:" in the two fields, but I still get the error.

Any pointers / tips on these probs would be much appreciated.

Many thanks

Winger







.

Relevant Pages

  • Re: reference a tab control?
    ... The tab control is not part of the reference. ... Just use the same thing as if the subform is sitting directly on the main ... >do I reference a field in the subform from the parent form? ...
    (microsoft.public.access.formscoding)
  • Formula Referencing of a field on a tabcontrol and subform
    ... My main form has a tab control on the bottom and on a particular tab is ... On this particular subform is a field is a date. ... But I can't get the full reference. ...
    (microsoft.public.access.formscoding)
  • Re: Referencing a field in a subform
    ... >> modify the code in it to reference a combo in the forms subform. ... the main form is itself a subform on a Tab Control and I can't get it ... Can anyone help me reference cboMentorSchool? ...
    (microsoft.public.access.formscoding)
  • Re: How to reference a listbox on a Subform>TabPage>MainForm?
    ... I'm trying to reference a List Box which is on a subform, ... of a tab control, which is on a main form. ... List Box MouseMove event to SetFocus on the list box and whichever ... The above uses the name of the subform *control* which is not guaranteed ...
    (microsoft.public.access.modulesdaovba)
  • Re: Referencing a field in a subform
    ... The tab control plays no part in referencing subforms. ... Pretend the subform is sitting on the mainform itself. ... >> Access Database Samples: www.rogersaccesslibrary.com ...
    (microsoft.public.access.formscoding)