Developing a Database

[Anthony Brown]

Hello All,

I want to develop a simple database where I can Input
records of customers, and also recall those records using
a form.

Ex. I type the cust id in a form and the remaining
information is auto populated.


Please Help

 

[PC Datasheet]

Start with a Customer table:

TblCustomer
CustomerID
FirstName
LastName
Address
City
State
ZipCode
etc

1. Create a query based on TblCustomer and set the sort on LastName to
ascending.
2. Use the form wizard to create your data entry form and base the form on the
query in 1.
3. Somewhere on your form add an unbound combobox.
a) Put the following expression in the rowsource property of the
combobox:
Select CustomerID, "LastName" & ", " & "Firstname" As Customer From
TblCustomer OrderBy Customer;
b) Set the BoundColumn to 1, Column Count to 2 and Column Width to 0;2
c) Put the following code in the AfterUpdate event of the combobox:

Dim Rst As DAO.Recordset
Rst.FindFirst "[CustomerID] = " & Me!NameOfYourCombobox
Me.Bookmark = Rst.Bookmark
Rst.Close

 

[Van T. Dinh]

It sounds like you should be able to start with the Contact database sample
and then modify to suit your needs. See the Microsoft Web site for
downloads:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6534F03C-518E-4868-
9BDC-20BAADB1C710&displaylang=en