DLOOKUP in access 2007 forms to auto populate selected fields

[Peter Simpson]

Hi


Firstly I am new to access so I am sorry if my questions seem silly to you guys.

I have a table called DEBTOR DETAILS and a form called DEBTOR DETAILS FORM that I use to populate it with. I am ok with this.
I have another table called FEEDBACK. I have a form called FEEDBACK which I use to populate this table. My problem is that I am spending too much time capturing the same data over and over again. Ideally what I would like is this:

On my FEEDBACK form I have an ACCOUNT NUMBER field. When I enter an account number, I would like it to pull information from the DEBTOR DETAILS table and have it populate some of the fields in the FEEDBACK form so that I don't have to duplicate work on data capturing.



Please help

[June7]

Should not be duplicating data in FEEDBACK table, just save the primary key from DEBTOR DETAILS.

Advise not to use spaces nor punctuation/special characters (underscore only exception) in name. Also, all upper case is not advised as it is harder to read. Better would be DebtorDetails or Debtor_Details. Many experienced developers will use a prefix to indicate object type, such as: frmDebtorDetails or frm_Debtor_Details.

[orange]

Peter,

You asked for help. My suggestion is that you write a description (5 or 6 lines) about the "business" for which you are developing this database. Start at a high level and gradually add some details. It is critical that you get your tables and relationships designed to meet your business facts.

From an Access naming perspective, you should avoid names with embedded spaces and/or that use special characters like @#$%&*(). It will cause a lot of syntax errors. Better to use alphanumerics and the underscore"_" only for names.

[Peter Simpson]

Hi June7
Thank you for responding.
As I said, I am new to access and I have no idea what you just said except for the capitals part. I used the wizards to construct everything so far and am still in the womb when it comes down to coding.

If I explain my process maybe it will help me to get on the same page as you.

I capture my customers data (Name, Surname, contact number, account number, address, arrears amount, balance, instalment and ID number) which is saved in the DEBTORS DETAIL table.
When I to capture any feedback on the FEEDBACK form, I want to enter the customers account number in the account number field and have that populate certain fields in the form from the DEBTORS FEEDBACK table so that I don't have to re-capture them. I tried getting screenshots but am not successful in posting them here for you to see.

[Peter Simpson]

Hi Orange
Thank you. I will start re-naming right away

The business is the following:
Companies hand over their bad debtors books to me. I then capture all the debtors personal information onto the database, including the account number. once the debtor has been contacted, I need to send feedback.

[orange]

Good start. A few questions to help readers understand your "business":

Is this a brand new database and business?
What is your experience/background?

-bad debtor's books (electronic/paper???)
-debtors (volume ??)
-account number (to what??)
-Can a debtor have multiple accounts eg bank1, bank2, finance company, retail store....???

Please describe debtor has been contacted in a sentence or 2 or an example.

-send feedback to whom???

Remember, we only know what you tell us!!

[June7]

I am still not sure what you want to accomplish. Select the debtors record from a combobox and save record identifier (autonumber or AccountNumber) into FEEDBACK. Displaying the debtor's other associated data on the form can be done by several methods but should not be saved into FEEDBACK.

Display methods discussed in this recent thread https://www.accessforums.net/showthread.php?t=68837

1. multi-column combobox

2. include lookup table in FEEDBACK form RecordSource

3. DLookup()

[Peter Simpson]

Debtor's book - Paper
Volume - 200 per week
Account number - the debtors account number with the creditor (eg: 13351/2)
Multiple accounts - Yes (eg 13351/2 and 13351/1)

When the debtor is contacted, we need to verify the following:
1. Is the debtor working?
2. When will the debtor be making a payment?
3. How much will the debtor be paying?
4. What is the debtors current address?

this feedback must then be communicated back to the creditor

[June7]

Your original question said 'pull information from the DEBTOR DETAILS table'. The 3 methods described can accomplish that. However, if this data is not already in DEBTOR DETAILS and you really do need to enter into FEEDBACK record, that is different issue.

[orange]

this feedback must then be communicated back to the creditor

and is that the end?

Your business in a nutshell is to identify
-where the debtor lives currently;
-if they work and where;
-when a payment will be made, and
-relay the info to the creditor???

[Peter Simpson]

[Peter Simpson]

Yes that is it in its simplest form

[Peter Simpson]

I have pasted the two forms, as you can see there is information on the debtor details form that I need on the feedback form, each form has its own table

[June7]

And what about the suggested methods make them unacceptable to resolve the issue?

[Peter Simpson]

I have tried the DLOOKUP but I cant seem to get it to work. I am very new to access and my coding skills are infantile