lookups

Article View: comp.databases.ms-access

Article #435

Back to comp.databases.ms-access Previous Next

#435

From: Bruce Collins
Date: Wed, 05 Nov 1997 00:00

13 lines
1868 bytes

I have two tables called A and B.  Table A has a field lookup to table B
which then fills in a couple of fields.  OK so far.
Now I also have a form based on table A.  If the item I want to lookup does
not exist in table B I am stuck, so I have made a command button which takes
me into a form for Table B so I can add the new item.  The problem is that
when I exit the table B form the new item does not appear in the field
lookup on the table A form.  If I then exit the table A form and come back
in again the new item appears OK.
What am I doing wrong?  Is there someone out there that can help this Access
novice?  I am running Access 97
Thanks in advance
Bruce Collins

Technical Details

Message-ID: <63pcu0$qf9$2@fep4.clear.net.nz>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,9550d423d62bce2f
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,9550d423d62bce2f
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 10d1ba,9550d423d62bce2f
X-Google-Attributes: gid10d1ba,public
X-Google-Thread: ff0ac,9550d423d62bce2f
X-Google-Attributes: gidff0ac,public
X-Google-Thread: f5bfb,9550d423d62bce2f
X-Google-Attributes: gidf5bfb,public
X-Google-Thread: 10bb27,9550d423d62bce2f
X-Google-Attributes: gid10bb27,public
X-Google-Thread: 10779a,9550d423d62bce2f
X-Google-Attributes: gid10779a,public
X-Google-Thread: 1163bd,9550d423d62bce2f
X-Google-Attributes: gid1163bd,public
From: "Bruce Collins" <your_login@clear.net.nz>
Subject: lookups
Date: 1997/11/05
Message-ID: <63pcu0$qf9$2@fep4.clear.net.nz>
X-Deja-AN: 287154964
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: CLEAR Net
Newsgroups: comp.databases.ms-access,es.comp.bd.ms-access,info.inet.access,microsoft.public.access,microsoft.public.access.developerstoolkit,microsoft.public.access.forms,microsoft.public.access.formsprogramming,microsoft.public.access.queries,microsoft.publi