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
"dsimpkins" wrote:
> 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
>
> --
> dsimpkins
>
>
> "Barry Gilbert" wrote:
>
> > It can be done, but not without a bunch of code. It depends on how
> > comfortable/adventurous you are with code.
> >
> > Barry
> >
> > "dsimpkins" wrote:
> >
> > > 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?
> > > --
> > > dsimpkins
|
Similar Threads
