Access 2003- Combo box answer filling in other fields.

[Nor-Cal Kevin]

The rundown:

I run a small construction company that is expanding rapidly. My methods
for tracking P.O. s are ridiculously archaic. The volume of work we're doing
is exploding and I need Access to start streamlining my process. I have
obained another contractors db setup and its working fairly well for what I
need it to do. But I need to tweak it just a bit so I can cut down the
amount of time I spend every night entering paperwork.

The question:

As part of my form that I use for data entry, there is a combo box that
lists all the checks we've recieved from the company we subcontract for.
There is also a text box that lists when the check was issued. The
information for the combo box is pulled from a table that lists the checks,
what date the checks were cut, and what dollar amount the check was.
Presently I am entering the date in manually. My situation is this: I would
like to make it so when I choose "check xyz" the form automatically enters
the coresponding date into the "Payment Date" field on my form.

I understand this might be a complex question that requires specifics, so
even any pointers towards tutorials or proper terminology would be greatly
appreciated.


*******As a side note: I also need a bunch of reports that show status of
P.O.s Status of payments, etc. Does anyone have any suggestions on a site
with some descent tutorials or a good book on the subject that might help me
out?


Thank you.

k.

I

 

[akphidelt]

Alright, not sure how it's set up and how far your access knowledge goes but
here is just a few observations I had.

As for the combo box for data entry what you want to do are these steps
(atleast this is what I do)

1) Attach the date field in to the combo box with the check number.
2) Change the column count to 2
3) Hide the date column if you want by setting the width to 0"
4) Create an after update event using Code
5) Type in the code
Me.textboxwithdate = Me.comboboxwithchecknumber.Column(1)

The way the columns work is that they start from 0. So usually your first
column is an ID number or in this case the check #. So Column(1) will have
the second column in your listing which in this example is the Date.

If you have any other databases questions or need more assistance just let
me know.