Re: A subform Link Child Fields, Link Master fields problem (newbie question)

Parent is a property that returns the form object of the
subform's parent form. You were not supposed to replace it.
Assuming the main form text box (or field) is named
StockSymbol, the control source should simple be:
=PARENT.StockSymbol

If you got prompts, then I would have to guess that you used
that in a query.

If you did use that in a subform text box's control source,
then you should get #Name if you forgot the = sign or if
StockSymbol is not really the name of the main form text box
or field.

If you have some kind of aversion to using the Parent
property, you could use the full reference:
=Forms!nameof mainform.StockSymbol
--
Marsh
MVP [MS Access]


raylopez99 wrote:
I found a hint--but just a hint--in a textbook on how to fix this
problem. Apparently, for at least Access 95 (the book is old) the
Form Design interface does not allow you to create a form from more
than one table (unlike the Form Wizard, which does). To trick the
interface, you must set up a query, and base the form on the query.

Anybody actually done this for Access 2003? Right now my workaround
is fine, but for future reference I'd like to know.
.

Relevant Pages

  • Re: Query vs form with child & parent: Deleting rows
    ... If you delete a parent record, and have 5 related tables to that main ... These child records will delete even if you just delete main ... the setup of the query WILL NOT EFFECT this ... So, if we have Customers, and Invoices tables, a left join would give us: ...
    (microsoft.public.access.forms)
  • Re: Deleting duplicate parents and grouping children to single par
    ... You will need to build the action query as a SQL statement to execute. ... To reassign 24 to 18, and then kill 24, this is the basic code: ... duplicate fields and then use a MIN function to identify the first ParentID ... undesirable parent record. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How do i use subforms and reports with self joins??
    ... Fortunately i only have to deal with 4 or 5 generations of assemblies. ... have done the nlevel recursive query as crazily complicated as it is. ... My main form is based on T-SerialNumbers as S/N individuates each item. ... A S/N may either be a parent assembly, A sub-Assembly or a Sub Component ...
    (microsoft.public.access.forms)
  • Re: Updating and Retrieving Data
    ... How do I keep pending parent and children in synch? ... that actually exist in the database. ... use those placeholder values for your pending child rows. ... "SELECT SCOPE_IDENTITY" query to retrieve the last identity ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Re-run a Query Based on Previous Results
    ... I'm using the first query from your post, ... Does fnProgenitor expect two arguments? ... Dim rs As DAO.Recordset ... I have a function I use to determine the ROOT LEVEL parent (the ...
    (microsoft.public.access.queries)
Loading