Re: Can't buikd a Link between Unbound Forms

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paul Overway (paul_at_I.hate.spam.logico-solutions.com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 10:07:26 -0500

Manually typing in the field or control names will work. It may be
inconvienent, but the linker tool has no way of knowing which
fields/controls should be linked with an unbound form. 

-- 
Paul Overway
Logico Solutions
http://www.logico-solutions.com
"Dolfan" <Dolfan@discussions.microsoft.com> wrote in message 
news:2A1C2A17-6A0E-4A5C-80CE-891B7C52DDE2@microsoft.com...
>I have a form and several sub forms on different tabs that are linked on 
>the
> primary key of the main form and foreign key in the sub forms. When I go 
> into
> the properties of the form/subform and click on either the link child or
> master fields to change the linking I get a message saying "Can't build a
> link between unbound forms", and don't get the field linker box to open.
> Access then takes out the field name in the child or master link line that 
> I
> was on. The forms are bound by their respective queries.
>
> I can link the 2 manually by putting in the fields, but not with the field
> linker box. I can create a link between the forms and wizard, but get the
> error when I manually attempt to change them.
>
> Even when I create a new form with a sub form that doesn't have tabs I get
> the same error.
>
> There are relationships between all of the tables.
>
>
> The form/subform connections work 99% of the time, but I get a ODBC call
> error on the sub form (connected to SQL Server 2000 Back end.) every once 
> in
> a while, and then lose connection to all the sub forms. I am trying to 
> figure
> out if the 2 things are connected.
>
> Thanks in advance for your help, I really appreciate it.
>
> Dolfan

Relevant Pages

  • Re: Automatically logging in to SQL Server (w/Access Front End)
    ... Not sure if this works for 2 connections but.... ... I use this procedure to re-create links to SQL Server. ... Public Sub LinkSQLServerTables ... Set dbs = CurrentDb ...
    (microsoft.public.access.modulesdaovba)
  • using Net::SSH::Expect within a thread fails
    ... list of IP addresses from the IAD module and then create a few threads ... sub threadsub { ... my $exe_user = shift; ... will make a lot of connections once it's up and running. ...
    (perl.beginners)
  • IRowConsumer webpart runat client
    ... (with runat client because i'm using an OWC Pivottable to interface). ... many connections can ... public override ConnectionRunAt CanRunAt() ... Public Overrides Sub EnsureInterfaces() ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: 2 ways to close a connection
    ... great job in this newsgroup, ... whether to rely on GC to close the connections for you. ... > Sub Main ... > "Cor Ligthert" wrote in message ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Program Fails When Parameter Fixed Constants are Changed (F77) ??
    ... routine that aren't able to be resolved by the linker. ... statements, etc. but mentaining program structure, modules, relevant ... delete External dcpval from Sub DCpZeros." ... Please review my reply to James ...
    (comp.lang.fortran)