Re: Entering data onto a form
- From: connorspops <connorspops@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 7 Nov 2006 07:41:02 -0800
Try setting the value of the reference field to =DMax("[Reference]",
"Table_name", "([Client] = forms![form_name]![client]) AND ([Partner]
=forms![form_name]![partner])") . You will have to enter both the client
and partner to avoid getting the wrong reference number, but it should work.
"Duane Hookom" wrote:
So you have only one table?.
--
Duane Hookom
MS Access MVP
"Mellstock" <ireeve138@xxxxxxxxxxx> wrote in message
news:1162713296.571085.193300@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thank you. I have downloaded the sample which was helpful. What I need
to do can be done.
I maybe missing something but I could see what he was suggesting but
not how you do it.
Do I need to write a macro or specify criteria in a query ?
Currently the table is structured
Column 1 Partners 78 entries (13 Partners * 6 Clients)
Column 2 Clients 78 entries (6 Clients * 13 Partners)
Column 3 Reference 78 entries Each Partner/Client/Reference is
unique
Entering a Partner reduces the number of possible Client/References to
6
Susequently entering a Client leaves only 1 possible reference
What I am seeking to achieve is entering that reference automatically
1) to save time 2) to avoid corrupt data.
Apologies for multiple entries. I am new to newsgroups but keen to
crack this problem,
Duane Hookom wrote:
It would help if we knew your table structure. It sounds like you want
cascading combo boxes. Roger Carlson has a small sample of this at his
web
site www.RogersAccessLibrary.com
--
Duane Hookom
MS Access MVP
"Mellstock" <ireeve138@xxxxxxxxxxx> wrote in message
news:1162663958.262317.238590@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I work with 13 partners for 6 core clients. Each partner has a unique
reference with each client. I have a table with the headings partner /
client / referece. 78 entries in total. When I am preparing an invoice
I need to enter these details onto a form with separate fields for
partner, client and reference.
I can enter the partner (easily from a look up list of 13) and client
(easily from a look up list of 6). Having entered the partner and
client respectively onto the forms there can now only be one reference.
Is there any way of automatically entering the reference having
previously entered the partner and client. At the moment I am faced
with entering it from a look up list of 78!
Anybody with any ideas? Thank you.
- References:
- Entering data onto a form
- From: Mellstock
- Re: Entering data onto a form
- From: Duane Hookom
- Re: Entering data onto a form
- From: Mellstock
- Re: Entering data onto a form
- From: Duane Hookom
- Entering data onto a form
- Prev by Date: RE: AUTODATE
- Next by Date: Re: Nearest geographical neighbour table design...
- Previous by thread: Re: Entering data onto a form
- Next by thread: Re: Table Paths
- Index(es):
Relevant Pages
|
