Auto fill from existing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to get the field in a database table to auto fill - similar to
excel - when your using the same information later. ie I have a sale to
xyz corporation for PO # 123-DEF on 8-20-06 and on 9-1-06 I have another sale
to xyz corporation for PO # 123-DEF (different product, & amount). Can you
get Access to autofill the customer and PO info without setting a new
relationship to another table?
 
It can be done, but not without a bunch of code. It depends on how
comfortable/adventurous you are with code.

Barry
 
Considering I'm a novice - coding isn't really my expertise, however, how
does anybody learn but by doing it. I'll take any help on this I can get.
As long as I can get an explanation of what goes where and how it works I do
ok.
Thanks
 
Actually, I mis-spoke. It might be simpler.
If you are just using a table, not entering data through a form, you can use
each column's lookup functionality to do this. For example, in the design of
your table, put your cursor on the Vendor column. Go to the Lookup tab and
change Display Control to "combobox". In the rowsource property, click the
elipsis(...) to the right and build a query that reads the Vendor column from
the same table. Make sure the Limit To List property at the bottom says No.

Now when you look at the table in datasheet view, you can select a value
from that column or it will auto-fill based on values previously entered in
the column.

Barry
 
THANKS It Works Great!

--
dsimpkins


Barry Gilbert said:
Actually, I mis-spoke. It might be simpler.
If you are just using a table, not entering data through a form, you can use
each column's lookup functionality to do this. For example, in the design of
your table, put your cursor on the Vendor column. Go to the Lookup tab and
change Display Control to "combobox". In the rowsource property, click the
elipsis(...) to the right and build a query that reads the Vendor column from
the same table. Make sure the Limit To List property at the bottom says No.

Now when you look at the table in datasheet view, you can select a value
from that column or it will auto-fill based on values previously entered in
the column.

Barry
Click to expand...
 
Back
Top