Entering data into forms

  • Thread starter Thread starter Mellstock
  • Start date Start date
M

Mellstock

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 / reference. 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.
 
in the control on the form, set the default value of the ReferenceID to
a DLookup, maybe...
Just specify the other two fields as criteria for your lookup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering data onto forms 1
Entering data onto a form 11
Exporting to Excel from Switchboard (Switchboard Manager) 1
DoCmd.OpenReport 14
Record changed value of field (previous value) 5
Query runs perfectly but report pulls wrong information (Acces 2007) 0
Excel Message box called if 1 of 3 options is entered. 4
"Enter" button 1

Back
Top