Access Form Help Needed!!

[ElPerson]

Hi



I have access form for sale management, and I want access to suggest the customer name from the previous entered in the table , and if i like i can click on the desired one or else i complete entering the data

see the attachement

Thank you

[June7]

Sounds like you want a combobox, not a textbox. This is basic Access functionality. Have you studied an introductory tutorial book?

[Micron]

the previous entered in the table

Think of a table of records being like a bucket of marbles. In spite of how records appear, there is no guarantee of order. You would be better off basing order on a sorted query. However, you would need to utilize a field that can provide order to that query (such as date or auto number descending) and retrieve the Min of that value (or Max if you sort ascending)

[rpeare]

Further.... you should not be relying on a free form field to enter your customers, those should go into a separate table and you should be storing them on a separate table storing only the foreign key in your 'sales' table.

just as an example. If you allow free form entry of a customer name:

CustomnerA
Customer A
CustomerA
cus tomer a

would all appear as different customers when, in fact they are the same.

What you should have is a separate customer table

C_ID  C_Name ----> other customer related fields
1     Customer A
2     Customer B

and store the C_ID (primary key field, usually an autonumber) in your 'invoice' or 'orders' table.